Re: 4 billion record limit?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: Paul Caskey <paul(at)nmxs(dot)com>, Postgres Users <pgsql-general(at)postgresql(dot)org>
Subject: Re: 4 billion record limit?
Date: 2000-07-25 20:40:51
Message-ID: Pine.LNX.4.21.0007251951260.546-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2000-07-25 20:54:04 Re: General Trigger Functions
Previous Message Peter Eisentraut 2000-07-25 20:40:45 Re: Hints about how to debug pg_dump problem?

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2000-07-25 22:03:26 Re: 4 billion record limit?
Previous Message Eduardo Kotujansky 2000-07-25 20:09:59 procedure language