Re: pg_dump versus hash partitioning - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: pg_dump versus hash partitioning
Date
Msg-id a7ef6212-f9fe-6826-9640-5dac54327140@dunslane.net
Whole thread Raw
In response to Re: pg_dump versus hash partitioning  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_dump versus hash partitioning
List pgsql-hackers
On 2023-02-01 We 20:03, Tom Lane wrote:
>
> Anyway, after re-reading the old thread I wonder if my first instinct
> (force --load-via-partition-root for enum hash cases only) was the
> best compromise after all.  I'm not sure how painful it is to get
> pg_dump to detect such cases, but it's probably possible.
>
>             


Given the other problems you enumerated upthread, I'd be more inclined
to go with your other suggestion of
"--load-via-partition-root=on/off/auto" (with the default presumably
"auto").


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com




pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [PATCH] New [relation] option engine
Next
From: Jeff Davis
Date:
Subject: Move defaults toward ICU in 16?