| From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org,Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com> |
| Subject: | Re: How to avoid dead rows in tables. |
| Date: | 2018-08-06 07:13:39 |
| Message-ID: | 1286FBF3-B1BB-4AC6-87DC-250636E0A57A@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 6 August 2018 09:04:45 CEST, Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bejita0409 | 2018-08-06 09:48:37 | How to revoke privileged from PostgreSQL's superuser |
| Previous Message | Raghavendra Rao J S V | 2018-08-06 07:04:45 | How to avoid dead rows in tables. |