Re: pg_dump versus enum types, round N+1

2024-03-24 Thread Tom Lane
Andrew Dunstan writes: > On Sat, Mar 23, 2024 at 3:00 PM Tom Lane wrote: >> So I'm glad we found that sooner not later, but something needs >> to be done about it if [1] is to get committed. It doesn't seem >> particularly hard to fix though: we just have to track the enum >> type OIDs made in

Re: pg_dump versus enum types, round N+1

2024-03-23 Thread Andrew Dunstan
On Sat, Mar 23, 2024 at 3:00 PM Tom Lane wrote: > I have a patch in the queue [1] that among other things tries to > reduce the number of XIDs consumed during pg_upgrade by making > pg_restore group its commands into batches of a thousand or so > per transaction. This had been passing tests, so

pg_dump versus enum types, round N+1

2024-03-23 Thread Tom Lane
I have a patch in the queue [1] that among other things tries to reduce the number of XIDs consumed during pg_upgrade by making pg_restore group its commands into batches of a thousand or so per transaction. This had been passing tests, so I was quite surprised when the cfbot started to show it