Re: Pg_repack

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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 

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux