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
Regards,
Raghavendra Rao J S V
Mobile- 8861161425
Raghavendra Rao J S V
Mobile- 8861161425
