Re: Can you run out of oids?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris Hoover" <revoohc(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can you run out of oids?
Date: 2006-08-02 03:49:39
Message-ID: 29699.1154490579@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Chris Hoover" <revoohc(at)gmail(dot)com> writes:
> Since we upgraded to 8.1.3, I noticed that I can create tables without an
> oid column. I am wondering if I should consider trying to rebuild the
> existing tables to be built without OID.

As things are currently set up, a table that's uselessly using OIDs
isn't going to have any serious impact on any other table. It might be
worth doing ALTER .... SET WITHOUT OIDS just to save the microseconds
required to generate an OID for each insert --- but I don't see another
reason.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2006-08-02 03:52:18 Re: Best Procedural Language?
Previous Message Merlin Moncure 2006-08-02 03:37:05 Re: Best Procedural Language?