| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | jaya kumar <kumardba27(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Autovacuum------Doubts |
| Date: | 2024-04-08 16:21:32 |
| Message-ID: | CAMkU=1w9Zgxc6ZSPS1MN7W=psx7fpH-QYt=0c9gPYar3AK2gGA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Apr 8, 2024 at 5:27 AM jaya kumar <kumardba27(at)gmail(dot)com> wrote:
>
> Hi Team,
>
> The below updated parameter value has been set currently in
> postgresql.conf file.
>
> autovacuum_analyze_threshold and autovacuum_vacuum_threshold both
> parameter values set from 50 to 20.
>
> Created one table with 100 records. First, we deleted 21 records. after an
> autovacuum does not happen automatically. After again I deleted another 20.
> Out of 100 we delectated 40 records then the autovacuum happened
> automatically. As per the configuration Autocacuum will automatically
> delete 21 records in the table but my case does not happen.
>
If you want vacuuming by autovacuum to be driven entirely by
autovacuum_vacuum_threshold, then you should set
autovacuum_vacuum_scale_factor to zero.
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jaya kumar | 2024-04-08 16:35:41 | Re: Autovacuum------Doubts |
| Previous Message | Frank Wang | 2024-04-08 16:06:48 | A good tool for PostgreSQL admin - PuttyGPT = Putty + ChatGPT |