Skip site navigation (1) Skip section navigation (2)

Re: OID vs overall system performances on high load

From: Neil Conway <neilc(at)samurai(dot)com>
To: Eric Lauzon <eric(dot)lauzon(at)abovesecurity(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: OID vs overall system performances on high load
Date: 2005-05-30 04:02:44
Message-ID: 1117425764.23266.12.camel@localhost.localdomain (view raw or flat)
Thread:
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.


In response to

pgsql-performance by date

Next:From: Tobias BroxDate: 2005-05-30 09:19:51
Subject: timestamp indexing
Previous:From: Tom LaneDate: 2005-05-29 21:47:18
Subject: Re: OID vs overall system performances on high load

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group