Re: Pg_repack - Mailing list pgsql-admin

From Muhammad Imtiaz
Subject Re: Pg_repack
Date
Msg-id CACW1Ly0wG4MZ+OgAWBDZwPXmNW_--+iWqp3mmru40iu=C8v3aw@mail.gmail.com
Whole thread Raw
In response to Pg_repack  (Sathish Reddy <sathishreddy.postgresql@gmail.com>)
List pgsql-admin
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

On Mon, Aug 12, 2024 at 4:48 PM Sathish Reddy <sathishreddy.postgresql@gmail.com> wrote:
Hi 
  We 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.


Thanks 
Sathishreddy 

pgsql-admin by date:

Previous
From: "William Sescu (Suva)"
Date:
Subject: No Message "PostgreSQL, contrib, and documentation successfully made. Ready to install."
Next
From: Domen Šetar
Date:
Subject: Function problem