Is it Postgres better?

[Guest_imported]

I want to create a db about 5,000,000 rows.
MySQL or Postgres...?
I want stability, speed.. and open source, or something really cheap

 

[devnull22]

depends what you want to do with the data.

MySQL was built to be fast (really fast) for reading.
Postgres has more options, i.e. sub selects, transactions ...

my self, i'd prefer mysql as it's easier to admin and there seems to be more docs for mySQL.

but here's an article that compares the two.

http://www.phpbuilder.com/columns/tim20000705.php3

cheers devnull22

http://www.photoflux.com

http://www.clickEval.com

--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !

 

[rycamor]

I recommend MySQL for smaller applications (not necessarily in size of data, but in complexity). If your application has some complex interactions that you need to maintain, then PostgreSQL is probably better, since it supports Foreign Key constraints, transactions (well MySQL now has transactions, if you want), and it really has almost all the "enterprise features" that you can find in Oracle or DB2.