Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuumdb idle processes - Mailing list pgsql-admin

From Nikhil Shetty
Subject Re: vacuumdb idle processes
Date
Msg-id CAFpL5VyrQAzmSTwKb9nDSirevdG57Q9WSTXGD5tOPsHA3QVXug@mail.gmail.com
Whole thread Raw
In response to Re: vacuumdb idle processes  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-admin
Tree view
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.janes@gmail.com> wrote:


On Fri, Jun 11, 2021 at 1:58 PM Nikhil Shetty <nikhil.dba04@gmail.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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL SSL params
Next
From: Tom Lane
Date:
Subject: Re: pg_restore: warning: invalid creation date in header