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

Re: Migration \ OID question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lipker, Joseph" <Joseph(dot)Lipker(at)WRECO1(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Migration \ OID question
Date: 2008-12-23 05:02:03
Message-ID: 15558.1230008523@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Lipker, Joseph" <Joseph(dot)Lipker(at)WRECO1(dot)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

In response to

pgsql-admin by date

Next:From: Magnus HaganderDate: 2008-12-23 08:54:23
Subject: Re: publishing changelogs on pgweb
Previous:From: Tom LaneDate: 2008-12-23 04:50:52
Subject: Re: Psql errors

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