Re: alter table xxx set unlogged take long time

2022-07-28 Thread Joe Conway
On 7/28/22 03:47, James Pang (chaolpan) wrote: Does "wal_level=minimal" help reducing wal emitting a lot for COPY and CREATE INDEX? We plan to remove "set unlogged/log" , instead , just set "wal_level=minimal" ,then COPY data in parallel, then create index. (Note - please don't top post on

RE: alter table xxx set unlogged take long time

2022-07-28 Thread James Pang (chaolpan)
Does "wal_level=minimal" help reducing wal emitting a lot for COPY and CREATE INDEX? We plan to remove "set unlogged/log" , instead , just set "wal_level=minimal" ,then COPY data in parallel, then create index. Thanks, James -Original Message- From: Joe Conway Sent: W