Postgres Pro
Downloads
Home   >   mailing lists

Re: How to avoid dead rows in tables. - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: How to avoid dead rows in tables.
Date
Msg-id 1286FBF3-B1BB-4AC6-87DC-250636E0A57A@a-kretschmer.de
Whole thread Raw
In response to How to avoid dead rows in tables.  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Raghavendra Rao J S V
Date:
Subject: How to avoid dead rows in tables.
Next
From: Alexandru Lazarev
Date:
Subject: Re: Who and How is responsible for released installations packagesand 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/)