Re: Practical maximums (was Re: [GENERAL] PostgreSQL theoretical maximums.)

2006-07-30 Thread Peter Eisentraut
Ron Johnson wrote: > 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? The evasive answer is that you probably don't run regular full pg_dump on such databases. > Are there any plans

Practical maximums (was Re: [GENERAL] PostgreSQL theoretical maximums.)

2006-07-30 Thread Ron Johnson
-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 ch

Re: [GENERAL] PostgreSQL theoretical maximums.

2006-07-27 Thread David Gagnon
Hi, Have a look at: http://www.postgresql.org/about/ /David 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

Re: [GENERAL] PostgreSQL theoretical maximums.

2006-07-27 Thread Peter Eisentraut
Karen Hill wrote: > How many tables and rows 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? > > What is

Re: [GENERAL] PostgreSQL theoretical maximums.

2006-07-27 Thread Richard Huxton
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

[GENERAL] PostgreSQL theoretical maximums.

2006-07-27 Thread Karen Hill
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? What is an effective way to predict database s

[GENERAL] PostgreSQL theoretical maximums.

2006-07-27 Thread Karen Hill
How many tables and rows 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? What is an effective way to predict d