From: Tom Lane <tgl@sss.pgh.pa.us>
To: Lipker, Joseph <Joseph.Lipker@WRECO1.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Migration \ OID question
Date: Tue, 23 Dec 2008 00:02:03 -0500
Message-ID: <15558.1230008523@sss.pgh.pa.us> (raw)
In-Reply-To: <C10317901E94094383071D851A6272E3038AA516C9@WAFEDIXMCMS14.corp.weyer.pri>
References: <C10317901E94094383071D851A6272E3038A9E147F@WAFEDIXMCMS14.corp.weyer.pri>
<9562.1229745736@sss.pgh.pa.us>
<C10317901E94094383071D851A6272E3038AA516C9@WAFEDIXMCMS14.corp.weyer.pri>
"Lipker, Joseph" <Joseph.Lipker@WRECO1.com> writes:
> You mentioned "performance glitches". What would those be? Errors or system performance slowdowns.
Slowdowns --- specifically, the behavior is "generate next sequential
OID, probe index to see if it exists in table, repeat until not".
So if you've got a long run of consecutive OIDs in the same table,
when the OID counter reaches that point it could take a while to
assign the next free OID successfully. This would manifest as a slower
than expected INSERT.
regards, tom lane
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, Joseph.Lipker@WRECO1.com
Subject: Re: Migration \ OID question
In-Reply-To: <15558.1230008523@sss.pgh.pa.us>
* 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