Practical maximums (was Re: PostgreSQL theoretical maximums.)

-----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-----