[Leaplist] curious about mysql vs postgres...

[John Simpson]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 2008-10-01, at 1914, tom foster wrote:
>
> I'm wondering whether either one is "easier" than the other, or are
> they about the same but the plumbing is so different that one seems
> more difficult?
>
> "LAMP" is a more common acronym than "LAPP", after all.

several years ago i had a job where i was doing some hard-core  
database stuff- some tables had hundreds of millions of records, and  
the whole thing had to be able to find specific data very quickly. we  
did some testing back then, and the conclusion we reached was that  
mysql was a bit faster if the data set rarely changes, but not by  
much... and if the data set were being updated on any kind of a  
regular basis, postgresql was better. (we also discovered that XFS was  
a lot better than EXT3 for huge files, both in terms of supporting  
them to begin with, and in terms of access times for seeking within  
the huge files.)

again, that was several years ago, i want to say sometime around 2002.

nowadays i use postgresql for pretty much everything... i don't do  
anything really "big" with it, i think my biggest database is the  
automatic anti-spam blacklist. the server does have mysql installed,  
but i just looked and there are no active databases in it.


- --------------------------------------------------------
| John M. Simpson  --  KG4ZOW  --  Programmer At Large |
| http://www.jms1.net/                 <jms1 at jms1.net> |
- --------------------------------------------------------
|   Hope for America  --  http://www.ronpaul2008.com/  |
- --------------------------------------------------------





-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)

iEYEARECAAYFAkjnnd4ACgkQj42MmpAUrRqCRwCfQs3JbYqr8AUVPW75fDXCfVVD
SJIAn1MuyS7tqr4rVhIegkiP11/YzrnS
=dFL6
-----END PGP SIGNATURE-----

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.