Re: MAX TABLE TUPLES and MAX ARRAY SIZE

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: "Mourad EL HADJ MIMOUNE" <mimoune(at)ensma(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: MAX TABLE TUPLES and MAX ARRAY SIZE
Date: 2002-06-10 17:31:57
Message-ID: 20020610133157.287ed96f.nconway@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 10 Jun 2002 18:03:38 +0200
"Mourad EL HADJ MIMOUNE" <mimoune(at)ensma(dot)fr> wrote:
> I want know the max number of tuples we can store in one Postgres table

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

> the max size of one dimension array (ex : INT8 []) we can store in column
> value.

I believe you can store as much as the attribute will hold (which is
1GB compressed in 7.1 and later), but I'm not completely sure.

Cheers,

Neil

--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2002-06-10 17:57:20 Re: Checking that Pg is running from a shell script
Previous Message Jan Wieck 2002-06-10 17:20:10 Re: [SQL] VIEWs and FOREIGN keys