On Fri, 2024-12-13 at 10:03 +0000, SASIKUMAR Devaraj wrote: > > When we are running vacuumdb for our database of 1.5TB it is > > generating approximately 60GB of WAL files? Any way we can > > reduce this WAL file generation? > > We were able to identify the table generating around 40GB in > few mins by vaccum process. It is partition table with dead > tuple less than 0.5 percent. What may be next steps? I think I told you: increase "max_wal_size" and enable "wal_compression". That should reduce the amount of WAL. Yours, Laurenz Albe
