Postgres Pro
Downloads
Home   >   mailing lists

Re: OID vs overall system performances on high load - Mailing list pgsql-performance

From Neil Conway
Subject Re: OID vs overall system performances on high load
Date
Msg-id 1117425764.23266.12.camel@localhost.localdomain
Whole thread Raw
In response to OID vs overall system performances on high load  ("Eric Lauzon" <eric.lauzon@abovesecurity.com>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: OID vs overall system performances on high load
Next
From: Rudi Starcevic
Date:
Subject: Re: slow queries, possibly disk io