Re: AW: [HACKERS] Re: OID wraparound: summary and proposal

2001-08-06 Thread Hannu Krosing
Zeugswetter Andreas SB SD wrote: > > > It seems to me, I guess and others too, that the OID mechanism should > be on a > > per table basis. That way OIDs are much more likely to be unique, and > TRUNCATE > > on a table should reset it's OID counter to zero. > > Seems to me, that this would be no

Re: AW: [HACKERS] Re: OID wraparound: summary and proposal

2001-08-06 Thread Alex Pilosov
On Mon, 6 Aug 2001, mlw wrote: > I think you are focusing too much on "ROWID" and not enough on OID. The issue > at hand is OID. It is a PostgreSQL cluster wide limitation. As data storage > decreases in price, the likelihood of people running into this limitation > increases. I have run into OID

RE: AW: [HACKERS] Re: OID wraparound: summary and proposal

2001-08-06 Thread Zeugswetter Andreas SB SD
> It seems to me, I guess and others too, that the OID mechanism should be on a > per table basis. That way OIDs are much more likely to be unique, and TRUNCATE > on a table should reset it's OID counter to zero. Seems to me, that this would be no different than a performance improved version of

Re: AW: [HACKERS] Re: OID wraparound: summary and proposal

2001-08-06 Thread mlw
I think you are focusing too much on "ROWID" and not enough on OID. The issue at hand is OID. It is a PostgreSQL cluster wide limitation. As data storage decreases in price, the likelihood of people running into this limitation increases. I have run into OID problems in my curent project. Geez, 40