From: | Siraj G <tosiraj(dot)g(at)gmail(dot)com> |
---|---|
To: | Ron <ronljohnsonjr(at)gmail(dot)com> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: AUTOVACUUM |
Date: | 2023-10-31 04:13:51 |
Message-ID: | CAC5iy63zByqOF=A8=-SghG5Q7DxULZd=u5GsPerA1p-85jE4uQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Ron
Thank you. I had this info already, but I am looking for
queries/scripts/reports for analysis purposes if these need to be tuned.
Regards
Siraj
On Mon, Oct 30, 2023 at 8:42 AM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
> On 10/30/23 06:20, Siraj G wrote:
> > Hello -
> >
> > What are the dictionary objects/scripts we have to check if AUTOVACUUM
> > parameters are set correctly and need any tuning?
>
> On Linux:
> psql -c "SHOW ALL;" | grep "^ autovacuu"
>
>
> Then exit $PGDATA/postgresql.conf
>
> --
> Born in Arizona, moved to Babylonia.
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | MAILBOX-DBS | 2023-10-31 08:57:33 | postgresql backups to rubrik anyone |
Previous Message | Dan Smith | 2023-10-30 14:29:17 | Re: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%') |