Re: postgres limitation

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: a <hong(at)cs(dot)purdue(dot)edu>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgres limitation
Date: 2001-01-27 02:07:00
Message-ID: Pine.BSF.4.31.0101262205460.25644-100000@thelab.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message adb 2001-01-27 02:50:47 how do you run your backups?
Previous Message Alfonso Peniche 2001-01-27 01:50:22 Re: get last sequence