From: Neil Conway <neilc@samurai.com>
To: Eric Lauzon <eric.lauzon@abovesecurity.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: OID vs overall system performances on high load
Date: Mon, 30 May 2005 14:02:44 +1000
Message-ID: <1117425764.23266.12.camel@localhost.localdomain> (raw)
In-Reply-To: <F7B73864DD39FA40B6C56B3CE0D4D1CB1B4466@asdc003.abovesecurite.lan>
References: <F7B73864DD39FA40B6C56B3CE0D4D1CB1B4466@asdc003.abovesecurite.lan>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: neilc@samurai.com, eric.lauzon@abovesecurity.com
Subject: Re: OID vs overall system performances on high load
In-Reply-To: <1117425764.23266.12.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox