"Lipker, Joseph" <joseph.lip...@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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
