Re: postgres limitation - Mailing list pgsql-general

From The Hermit Hacker
Subject Re: postgres limitation
Date
Msg-id Pine.BSF.4.31.0101262205460.25644-100000@thelab.hub.org
Whole thread Raw
In response to postgres limitation  ("a" <hong@cs.purdue.edu>)
List pgsql-general
On Fri, 26 Jan 2001, a wrote:

> Hi,
>
> Is there any document about the limitation of postgres
> like the total size of one table

none that we are aware of ...

> the max row number of a table

2^32 ... limitation is the OID size, which is currently a 32bit int ...
move to 64bit int's, and then your max row number is 2^64 :)

> the max size of a row...

8k in pre v7.1, no limit in v7.1 an dlater ...



>
> Thanks
> Feng
>
>
>

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org


pgsql-general by date:

Previous
From: Alfonso Peniche
Date:
Subject: Re: get last sequence
Next
From: adb
Date:
Subject: how do you run your backups?