Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1lsRm2-0003gq-NC
	for pgsql-admin@arkaria.postgresql.org; Sun, 13 Jun 2021 15:11:42 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1lsRm1-0007Bs-Gm
	for pgsql-admin@arkaria.postgresql.org; Sun, 13 Jun 2021 15:11:41 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <nikhil.dba04@gmail.com>)
	id 1lsRm1-0007Bj-5q
	for pgsql-admin@lists.postgresql.org; Sun, 13 Jun 2021 15:11:41 +0000
Received: from mail-il1-x12b.google.com ([2607:f8b0:4864:20::12b])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <nikhil.dba04@gmail.com>)
	id 1lsRlv-0005iP-Jz
	for pgsql-admin@postgresql.org; Sun, 13 Jun 2021 15:11:40 +0000
Received: by mail-il1-x12b.google.com with SMTP id t6so10012650iln.8
        for <pgsql-admin@postgresql.org>;
 Sun, 13 Jun 2021 08:11:35 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20161025;
        h=mime-version:references:in-reply-to:from:date:message-id:subject:to
         :cc;
        bh=6nR+j4gW5HUdobxx0tB1eYBj23G++e25lkrp80jhkpk=;
        b=JDpl6b9lcIUKWHF+WiymFBBmJLlyksXFliks/ulm2Db9a2+xMhGDi/5A8ZyzTq7RHO
         9B2JGIYAS8V2gjpqFAbRqASJIDbtVeYAyGaQJwlZPW5qn9dovujPaoAyf9S01XJP2/LL
         8180sAAtnnaeNuNPdZDGMxfcvAFseS7WGcQ2Al7A7MsNDJq61Mj9WA4CHkpgz4HbWr39
         8IxOtLQ6D03NdcOJ97nYvwRZC55UkTT0S9+SQNgXPOaOXqO7Js8gVnKdsVPORFh2z4EC
         lB7cIcB0Xbz8QADZbZKknOKW5RXism5sFdO0zkuBzPq8I8cYieGL3+gJqPuur57d4pyG
         GJIA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:mime-version:references:in-reply-to:from:date
         :message-id:subject:to:cc;
        bh=6nR+j4gW5HUdobxx0tB1eYBj23G++e25lkrp80jhkpk=;
        b=IaAebc76uqeGh5d4Tv1MgvLNBdrDJC0EPKGuSc5tHJV8LsQQXbilu16PBNNoOdhZTZ
         suOF9A3j9lhmf05CtQqRGJA839dtRklMkUF8O2c1C9oh45hpMjRjqd7QIRXNSbKC5n1J
         h4W+BSinMB5tGOUncNi76PBa2mp43zJoxEk/cC+0WefuJQ/Yl/evhHaQRij/4IFf/mrD
         B2dPYtcBE8KpunPnQExGX7J0jnzw0vSVd1am0SbwlChQ2T9nwM6c7+7/vMwxEwvTLUCn
         lAFmnRALgBGgcKuyLLPOqnU3Bhd97F+VzS3EIDN33WwDo8t2Q5Igtpnse0UhJgBoJqxp
         gBug==
X-Gm-Message-State: AOAM531gqGrf0JTAGSx0YVAn+qVJKmfDm1/Xb/Sl6uLRftjeQxNDM63H
	9pcbfGtdtTGPS1Nj+MXK0CcuAu7SJEURCzK8pto=
X-Google-Smtp-Source: 
 ABdhPJw9lE2Db440vui210rS5+sS7meuLJYcgl1uUJKr29ts2nZP811vrZmZoHZ6l9MEhXrahRoipPg7qapRxL9P2Eg=
X-Received: by 2002:a05:6e02:1523:: with SMTP id
 i3mr10930157ilu.12.1623597092923;
 Sun, 13 Jun 2021 08:11:32 -0700 (PDT)
MIME-Version: 1.0
References: 
 <CAFpL5Vyb4dx=nqBZ_GB1M_TxA-3+E-bSav3fDQnVHW2udXEV5g@mail.gmail.com>
 <CAMkU=1yG3OW+4uf_z-ftEankrwRqg6bGqk2pvOEVrXanFRHyvw@mail.gmail.com>
In-Reply-To: 
 <CAMkU=1yG3OW+4uf_z-ftEankrwRqg6bGqk2pvOEVrXanFRHyvw@mail.gmail.com>
From: Nikhil Shetty <nikhil.dba04@gmail.com>
Date: Sun, 13 Jun 2021 20:41:21 +0530
Message-ID: 
 <CAFpL5VyrQAzmSTwKb9nDSirevdG57Q9WSTXGD5tOPsHA3QVXug@mail.gmail.com>
Subject: Re: vacuumdb idle processes
To: Jeff Janes <jeff.janes@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fb708d05c4a72707"
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/CAFpL5VyrQAzmSTwKb9nDSirevdG57Q9WSTXGD5tOPsHA3QVXug%40mail.gmail.com>
Precedence: bulk

--000000000000fb708d05c4a72707
Content-Type: text/plain; charset="UTF-8"

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

--000000000000fb708d05c4a72707
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div di=
r=3D"ltr">Hi Jeff,</div><div dir=3D"ltr"><br></div><div dir=3D"ltr"><blockq=
uote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-wi=
dth:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-=
left:1ex"><span style=3D"color:rgb(0,0,0);font-family:-webkit-standard;font=
-size:medium">What version of PostgreSQL is this?=C2=A0=C2=A0</span><br></b=
lockquote><div>Postgres version is 11.7.=C2=A0</div><div><br></div><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-wid=
th:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-l=
eft:1ex"><span style=3D"color:rgb(0,0,0);font-family:-webkit-standard;font-=
size:medium">What options do you run vacuumdb with?=C2=A0</span>=C2=A0</blo=
ckquote><div>Command is vacuumdb -avz -j 4</div><div><br></div><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1=
px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:=
1ex"><span style=3D"color:rgb(0,0,0);font-family:-webkit-standard;font-size=
:medium">Is it run as a superuser?</span></blockquote><div>=C2=A0</div><div=
>Yes, it is run as a superuser=C2=A0</div></div></div></div></div></div><br=
><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sun, J=
un 13, 2021 at 7:39 PM Jeff Janes &lt;<a href=3D"mailto:jeff.janes@gmail.co=
m">jeff.janes@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_=
quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-=
style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir=
=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">On Fri, Jun 11, 2021 at 1:58 PM Nikhil Shetty=
 &lt;<a href=3D"mailto:nikhil.dba04@gmail.com" target=3D"_blank">nikhil.dba=
04@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid=
;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hi,<=
div><br></div><div>I have done a setup to run vacuumdb with 8 parallel jobs=
 daily. It has been running quite well.</div></div></blockquote><div><br></=
div><div>What version of PostgreSQL is this?=C2=A0 What options do you run =
vacuumdb with?=C2=A0 Is it run as a superuser?</div><div><br></div><div>Che=
ers,</div><div><br></div><div>Jeff</div><blockquote class=3D"gmail_quote" s=
tyle=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:so=
lid;border-left-color:rgb(204,204,204);padding-left:1ex">
</blockquote></div></div>
</blockquote></div>

--000000000000fb708d05c4a72707--