Re: vacuum and autovacuum - is it good to configure the threshold at TABLE LEVEL?

From: amul sul <sulamul(at)gmail(dot)com>
To: vgmonnet(at)gmail(dot)com
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: vacuum and autovacuum - is it good to configure the threshold at TABLE LEVEL?
Date: 2018-11-27 10:24:43
Message-ID: CAAJ_b95eUBxpKNmcXnQALU=o_pfWiiF=Bp47vp2Y2g7VnMckhQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hopefully, this[1] will help you.

1] https://www.percona.com/blog/2018/08/10/tuning-autovacuum-in-postgresql-and-autovacuum-internals/

regards,
Amul
On Tue, Nov 27, 2018 at 11:50 AM rajan <vgmonnet(at)gmail(dot)com> wrote:
>
> Hi,
>
> Please suggest me on the following,
>
> 1. Is it better to configure autovacuum threshold at table level?
> 2. Is there any discussions in this forum which I can refer for
> understanding vacuum/autovacuum?
>
> Thanks in advance.
> Rajan.
>
>
>
> -----
> --
> Thanks,
> Rajan.
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2018-11-27 10:36:22 Re: Protect syscache from bloating with negative cache entries
Previous Message Kato, Sho 2018-11-27 10:05:29 Planning time of Generic plan for a table partitioned into a lot