On 6 August 2018 09:04:45 CEST, Raghavendra Rao J S V <raghavendra...@gmail.com> wrote: >Hi All, > > >auto vacuum is enabled in our database. But few of the tables contains >the >dead tuples more than 5,000 records. Number of dead rows are keep on >increasing day by day if we didn’t perform the vacuum full. Monthly >once we >are performing vacuum full by stopping application server process. >Later we >are restarting the application server process. > > > >How to avoid accumulating the dead tuples for those tables. Is there >any >other approach to remove the dead tuple’s without vacuum full/down >time. > > > >Note:- We are using the postgres version 9.2
You can tweak the autovacuum-settings, per default autovacuum will run if the table contains more than 20% + 50 dead tuples. Regards,Andreas -- 2ndQuadrant - The PostgreSQL Support Company
