Re: vacuumdb idle processes

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
>
>>

In response to

Browse pgsql-admin by date

  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