Hi, On Mon, Jun 2, 2025 at 11:14 AM Dilip Kumar <dilipbal...@gmail.com> wrote: > > > (I haven't figured out how to force postgres to > > create a visibility map for temp table within the transaction block). > > I haven't tested this, but I think if you do bulk copy into a table > which should mark pages all visible and after that if you delete some > tuple from pages logically it should try to update the status to not > all visible in vm? >
I found reliable way to create all three forks : begin; create temp table test (id int) on commit delete rows; copy test from 'data.csv' with (freeze); insert into test select generate_series(2000000, 3000000); delete from test where id % 500000 = 0; commit; -- Best regards, Daniil Davydov
