Thread: Database/table size

Database/table size

From
Timo Savola
Date:
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

From
Neil Conway
Date:
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 <neilconway@rogers.com>
PGP Key ID: DB3C29FC


Re: Database/table size

From
Timo Savola
Date:
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