From: | Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> |
---|---|
To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: vacuumdb idle processes |
Date: | 2021-06-13 15:11:21 |
Message-ID: | CAFpL5VyrQAzmSTwKb9nDSirevdG57Q9WSTXGD5tOPsHA3QVXug@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Jeff,
What version of PostgreSQL is this?
>
Postgres version is 11.7.
What options do you run vacuumdb with?
Command is vacuumdb -avz -j 4
Is it run as a superuser?
Yes, it is run as a superuser
On Sun, Jun 13, 2021 at 7:39 PM Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
>
>
> On Fri, Jun 11, 2021 at 1:58 PM Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>
> wrote:
>
>> Hi,
>>
>> I have done a setup to run vacuumdb with 8 parallel jobs daily. It has
>> been running quite well.
>>
>
> What version of PostgreSQL is this? What options do you run vacuumdb
> with? Is it run as a superuser?
>
> Cheers,
>
> Jeff
>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2021-06-13 15:13:29 | Re: pg_restore: warning: invalid creation date in header |
Previous Message | Tom Lane | 2021-06-13 15:04:35 | Re: PostgreSQL SSL params |