Re: vacuum to prevent wraparound

2023-06-06 Thread Laurenz Albe
On Tue, 2023-06-06 at 11:36 -0300, Marcos Pegoraro wrote: > I have a replica server using Postgres 14.4. > Replica is done using Publication/Subscription and I have triggers for > auditing, > so every record which comes from production is audited. > Some months ago I changed the way I was auditing

vacuum to prevent wraparound

2023-06-06 Thread Marcos Pegoraro
would be good to run vacuum on that table, it has lots of dead tuples, but that table is not used anymore, so why vacuum it ? I have to drop immediately that huge table that is not used anymore because it can stop the server to prevent a wraparound some day ? automatic aggressive vacuum to pr