Re: maximum number of rows in table - what about oid limits?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jonathan Bartlett <johnnyb6(at)sdf(dot)lonestar(dot)org>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: maximum number of rows in table - what about oid limits?
Date: 2001-06-08 14:38:02
Message-ID: 9559.992011082@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Jonathan Bartlett <johnnyb6(at)sdf(dot)lonestar(dot)org> writes:
> Besides compatibility, what breaks when you make OIDs/Txn IDs
> INT8s?

OIDs are part of the on-the-wire protocol (column type data returned
during a SELECT is in the form of OIDs). So extending OIDs to int8
would pose nontrivial client/server compatibility hazards.

> Maybe there should be a minor fork called Postgres64 which does
> this for those needing large tables.

I've been thinking it should be a compile-time option. But the protocol
issue is going to be a problem.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-08 14:41:22 Re: Re: [SQL] maximum number of rows in table - what about oid limits?
Previous Message Andreas Tille 2001-06-08 14:37:42 7.1 upgrade problems

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-06-08 14:41:22 Re: Re: [SQL] maximum number of rows in table - what about oid limits?
Previous Message Martín Marqués 2001-06-08 13:32:47 Re: Rule ON DELETE, to perform to DELETE querys !