Database/table size

От:

Timo Savola <timo.savola@codeonline.com>

Дата:

26 марта 2002 г. в 16:04:03

Hi. Sorry if this has already been answered or documented.

I lately got into an argument with a colleague about commercial vs. free
databases (how rare).

The question is, can PostgreSQL handle multi-gigabyte tables under
Linux? I skimmed through the PostgreSQL documentation about limitations.
It said "64 TB on all operating systems" and "limited to available disk
space and memory/swap space". So, how large tables can you have in
PostgreSQL on a Linux/Intel box? What about other Unices/architectures?

Timo

Re: Database/table size

От:

Neil Conway <nconway@klamath.dyndns.org>

Дата:

26 марта 2002 г. в 16:10:33

On Tue, 2002-03-26 at 16:03, Timo Savola wrote:
> The question is, can PostgreSQL handle multi-gigabyte tables under
> Linux? I skimmed through the PostgreSQL documentation about limitations.
> It said "64 TB on all operating systems" and "limited to available disk
> space and memory/swap space". So, how large tables can you have in
> PostgreSQL on a Linux/Intel box? What about other Unices/architectures?

http://www.ca.postgresql.org/docs/faq-english.html#4.5

Cheers,

Neil

-- 
Neil Conway 
PGP Key ID: DB3C29FC

Re: Database/table size

От:

Timo Savola <timo.savola@codeonline.com>

Дата:

26 марта 2002 г. в 16:14:36

On Tue, 2002-03-26 at 23:09, Neil Conway wrote:
> http://www.ca.postgresql.org/docs/faq-english.html#4.5

That's excatly what I was looking for, thanks. Didn't notice that
earlier, silly me. Now I can finish the argument. :)

Timo