"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 Hagander||Date: 2008-12-23 08:54:23|
|Subject: Re: publishing changelogs on pgweb|
|Previous:||From: Tom Lane||Date: 2008-12-23 04:50:52|
|Subject: Re: Psql errors |