| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
| Cc: | John Sidney-Woollett <johnsw(at)wardbrook(dot)com>, Hannu Krosing <hannu(at)skype(dot)net>, PostgreSQL general <pgsql-general(at)postgresql(dot)org>, Slony-I Mailing List <slony1-general(at)gborg(dot)postgresql(dot)org> |
| Subject: | Re: [Slony1-general] Is a high tab_reloid worrying? |
| Date: | 2006-04-17 16:01:46 |
| Message-ID: | 1640.1145289706@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jan Wieck <JanWieck(at)Yahoo(dot)com> writes:
> The other thing that is eating OID's are temporary objects. I personally
> consider the implementation of temp tables broken for precisely that
> matter. If your application uses temp tables, sooner or later it will
> cause an OID counter wrap around and then you run the risk of random
> transaction failures due to duplicate key errors on CREATE TEMP TABLE.
Not as of 8.1.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Pasher | 2006-04-17 16:33:20 | Will changing the server date/time cause problems? |
| Previous Message | Jan Wieck | 2006-04-17 14:55:47 | Re: [Slony1-general] Is a high tab_reloid worrying? |