Re: How to avoid dead rows in tables.

2018-08-06 Thread Andreas Kretschmer
On 6 August 2018 09:04:45 CEST, Raghavendra Rao J S V 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 w

How to avoid dead rows in tables.

2018-08-06 Thread Raghavendra Rao J S V
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. La