Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized

2025-07-23 Thread Dimitrios Apostolou
Hello Stepan! I can see you tested my patch by itself, and with the following command: On Monday 2025-07-21 07:58, Stepan Neretin wrote:       pg_restore -d "$DB_NAME" -j "$JOBS" --clean --if-exists --freeze "$DUMP_FILE" > /dev/null On the other hand, I have tested combining --freeze with -

Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized

2025-07-20 Thread Stepan Neretin
On Mon, Jul 21, 2025 at 12:24 PM Dimitrios Apostolou wrote: > > > > FWIW I implemented a pg_restore --freeze patch, see attached. It needs > > another patch of mine from [1] that implements pg_restore --data-only > > --clean, which for parallel restores encases each COPY in its own > transaction

Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized

2025-06-17 Thread Dimitrios Apostolou
FWIW I implemented a pg_restore --freeze patch, see attached. It needs another patch of mine from [1] that implements pg_restore --data-only --clean, which for parallel restores encases each COPY in its own transaction and prepends it with a TRUNCATE. All feedback is welcome. [1] https://ww