Postgres Pro
Downloads
Home   >   mailing lists

Re: Max number of rows in a table - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Max number of rows in a table
Date
Msg-id 22717.1070294198@sss.pgh.pa.us
Whole thread Raw
In response to Max number of rows in a table  (ow <oneway_111@yahoo.com>)
Responses Re: Max number of rows in a table  (ow <oneway_111@yahoo.com>)
List pgsql-hackers
Tree view 
ow <oneway_111@yahoo.com> writes:
>> --- Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Actually you can only have 4 billion SQL commands per xid, because the
>> CommandId datatype is also just 32 bits.  I've never heard of anyone
>> running into that limit, though.

> Wouldn't the above put a limit on a number of records one could have
> in table?

No.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Mike Mascari
Date:
Subject: Re: initdb should create a warning message [was Re: [ADMIN]
Next
From: Greg Stark
Date:
Subject: Re: [GENERAL] Was: Triggers, Stored Procedures, PHP