Re: 4 billion record limit? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: 4 billion record limit?
Date
Msg-id Pine.LNX.4.21.0007251951260.546-100000@localhost.localdomain
Whole thread Raw
In response to Re: 4 billion record limit?  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
Joseph Shraibman writes:

> I'm not too familiar with the postgres internals, but the oid tells
> postgres where the row is stored in the filesystem. So by the time
> you've run out of oid's you've probably run out of space on your
> filesystem.

The `tid' specifies the storage location. The `oid' is more or less an
arbitrary number as far as user tables are concerned.


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Hints about how to debug pg_dump problem?
Next
From: "Joel Burton"
Date:
Subject: (Fwd) RE: PostgreSQL, ODBC, Access (solution for me)