How to avoid dead rows in tables.
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
On 6 August 2018 09:04:45 CEST, Raghavendra Rao J S V <raghavendrajsv@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