Re: Add parallelism and glibc dependent only options to reindexdb - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Add parallelism and glibc dependent only options to reindexdb
Date
Msg-id 9495.1564332179@sss.pgh.pa.us
Whole thread Raw
In response to Re: Add parallelism and glibc dependent only options to reindexdb  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2019-07-28 10:07:27 -0400, Tom Lane wrote:
>> In the long run, might we ever switch to 64-bit OIDs?  I dunno.

> Depends on the the table, I'd say. Having toast tables have 64bit ids,
> and not advance the oid counter, would be quite the advantage over the
> current situation. Toasting performance craters once the oid counter has
> wrapped. But obviously there are upgrade problems there - presumably
> we'd need 'narrow" and 'wide' toast tables, or such.

Yeah, but I'd be inclined to fix toast tables as a special case,
rather than widening OIDs in general.  We could define the chunk
number as being int8 not OID for the "wide" style.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: ANALYZE: ERROR: tuple already updated by self
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT