-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Richard Huxton wrote: > Karen Hill wrote: >> How many tables can PostgreSQL theoretically and then >> practically handle? What is the largest database size >> possible? What was the biggest database you've ever had on >> PostgreSQL? What were the challenges and what kind of hardware >> and OS works best? > > Maximum number of tables etc. is a FAQ: > http://www.postgresql.org/docs/faqs.FAQ.html#item4.4 > > It's been running on unix-like systems for much longer than > Windows. Apart from that, the best system is probably determined > by your experience. > >> What is an effective way to predict database size when >> designing tables? > > Rule-of-thumb - assume 3-5 times the size of the raw data to > allow for overhead, indexes etc. Other than that, you can find > details of on-disk formats for rows towards the end of the > manuals.
I think I've read that there are multi-hundred GB PostgreSQL databases. Since pg_dump is single-threaded, how long does it take to back up such a database? (Obviously it would need modern LTO, SuperDLT, etc drives, either FC or U320.) Are there any plans of making a multi-threaded, or even multi-process pg_dump? - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEzUXgS9HxQb37XmcRAq7eAJ9HS4YWB5y/MQ7sGTpAMIvXKMTRhQCfXPEJ rYSLF4nTKv9AclJ2ZUHLVxE= =eBsW -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
