Horton

Re: 4 billion record limit?

Peter Eisentraut <peter_e@gmx.net>

View thread View on postgr.es
From: Peter Eisentraut <peter_e@gmx.net>
To: Joseph Shraibman <jks@selectacast.net>
Cc: Paul Caskey <paul@nmxs.com>, Postgres Users <pgsql-general@postgresql.org>
Date: 2000-07-25T20:40:51Z
Lists: pgsql-general, pgsql-novice 
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