Hi,
Pg_repack doesn’t use unlogged tables, but you can minimize WAL file size by enabling wal_compression in postgresql.conf. Additionally, you can fine-tune wal_buffers, checkpoint_timeout, and checkpoint_completion_target to better manage WAL file size.
Regards,
Muhammad Imtiaz
Pg_repack doesn’t use unlogged tables, but you can minimize WAL file size by enabling wal_compression in postgresql.conf. Additionally, you can fine-tune wal_buffers, checkpoint_timeout, and checkpoint_completion_target to better manage WAL file size.
Regards,
Muhammad Imtiaz
On Mon, Aug 12, 2024 at 4:48 PM Sathish Reddy <sathishreddy.postgresql@xxxxxxxxx> wrote:
HiWe have configure pg_repack on database.when we ran pg_repak it is using temporary table on repack once repack done it is going to swap temporary table to original .on these case it is genarate huse wal files and it getting size increase be end .We need help on these instead of using temporary table can we use unlog table on reduce these wal case.ThanksSathishreddy
