Re: OID vs overall system performances on high load

From: Neil Conway
Subject: Re: OID vs overall system performances on high load
Date: ,
Msg-id: 1117425764.23266.12.camel@localhost.localdomain
(view: Whole thread, Raw)
In response to: OID vs overall system performances on high load  ("Eric Lauzon")
List: pgsql-performance

Tree view

OID vs overall system performances on high load  ("Eric Lauzon", )
 Re: OID vs overall system performances on high load  (Andrew McMillan, )
 Re: OID vs overall system performances on high load  (Tom Lane, )
 Re: OID vs overall system performances on high load  (Neil Conway, )

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:

From: Tobias Brox
Date:
Subject: timestamp indexing
From: "Eric Lauzon"
Date:
Subject: Postgresql and xeon.