Horton

Re: OID vs overall system performances on high load

Neil Conway <neilc@samurai.com>

View thread
From: Neil Conway <neilc@samurai.com>
To: Eric Lauzon <eric.lauzon@abovesecurity.com>
Cc: pgsql-performance@postgresql.org
Date: 2005-05-30T04:02:44Z
Lists: pgsql-performance 
On Sun, 2005-05-29 at 16:17 -0400, Eric Lauzon wrote:
> So OID can be beneficial on static tables

OIDs aren't beneficial on "static tables"; unless you have unusual
requirements[1], there is no benefit to having OIDs on user-created
tables (see the default_with_oids GUC var, which will default to "false"
in 8.1)

-Neil

[1] Such as a column that references a column in the system catalogs.