| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2008-12-23 08:54:23 | Re: publishing changelogs on pgweb |
| Previous Message | Tom Lane | 2008-12-23 04:50:52 | Re: Psql errors |