Re: missing toast table for pg_policy - Mailing list pgsql-hackers

From Joe Conway
Subject Re: missing toast table for pg_policy
Date
Msg-id 1d68c831-5463-b205-fae1-02000f206e84@joeconway.com
Whole thread Raw
In response to Re: missing toast table for pg_policy  (John Naylor <jcnaylor@gmail.com>)
Responses Re: missing toast table for pg_policy
List pgsql-hackers
On 06/15/2018 02:40 PM, John Naylor wrote:
> On 2/19/18, Joe Conway <mail@joeconway.com> wrote:
>> The attached does exactly this. Gives all system tables toast tables
>> except pg_class, pg_attribute, and pg_index, and includes cat version
>> bump and regression test in misc_sanity.
>>
>> Any further discussion, comments, complaints?
> 
> Hi Joe,
> There's been a little bit-rot with duplicate OIDs and the regression
> test. The first attached patch fixes that (applies on top of yours).


Not surprising -- thanks for the update.


> It occurred to be that we could go further and create most toast
> tables automatically by taking advantage of the fact that the toast
> creation function is a no-op if there are no varlena attributes. The
> second patch (applies on top of the first) demonstrates a setup where
> only shared and bootstrap catalogs need to have toast declarations
> specified manually with fixed OIDs. It's possible this way is more
> fragile, though.

Hmmm, I'll have a look.


Thanks!

Joe

-- 
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pgsql: Store 2PC GID in commit/abort WAL recs for logicaldecoding
Next
From: David Gershuni
Date:
Subject: Re: Spilling hashed SetOps and aggregates to disk