Is there anyone out there with any really large installations ... +200GB?
I'm quickly getting there at 150GB. I don't trust MySQL to not corrupt itself when a table gets more than 1-3M rows in it. I have customers who use MySQL and the damn thing corrupts itself when tables get to have more than a few million rows. MySQL is just not a stable database when the number of records grows. It also has problems with lock contention. PostgreSQL is much better in both regards. I have PostgreSQL installations with easily over 1B rows and using 500GB of space without it breaking a sweat. Biggest Pg database I know of is several terabytes in size ala the Human Genome Project. :)
I'd love to talk and share ideas for managing large installs,
Accounts added, deleted, etc. via dbmail-user that are created via triggers. This is going to disappear at some point in favor of natively updating the database itself, but I haven't done that yet.
optimal db configurations,
FreeBSD 5.X (post 5.3 is best, IMHO. ie RELENG_5), PostgreSQL 8.0, AMD64, Perdition
replication
slony
/backups,
pg_dump
database maintenance,
pg_autovacuum
etc. Drop me a private email (mark a-t orcon.net.nz) or to the list.
Eh, I figure someone else may find it useful. -- Sean Chittenden
