Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to avoid dead rows in tables.

How to avoid dead rows in tables.

From
Raghavendra Rao J S V
Date:

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

Re: How to avoid dead rows in tables.

From
Andreas Kretschmer
Date:
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