Re: MAX TABLE TUPLES and MAX ARRAY SIZE - Mailing list pgsql-general

From Neil Conway
Subject Re: MAX TABLE TUPLES and MAX ARRAY SIZE
Date
Msg-id 20020610133157.287ed96f.nconway@klamath.dyndns.org
Whole thread Raw
In response to MAX TABLE TUPLES and MAX ARRAY SIZE  ("Mourad EL HADJ MIMOUNE" <mimoune@ensma.fr>)
List pgsql-general
On Mon, 10 Jun 2002 18:03:38 +0200
"Mourad EL HADJ MIMOUNE" <mimoune@ensma.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@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: [SQL] VIEWs and FOREIGN keys
Next
From: Thomas Beutin
Date:
Subject: Re: Checking that Pg is running from a shell script