Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXrv3-0008CL-Bh for pgsql-admin@arkaria.postgresql.org; Wed, 09 Apr 2014 12:47:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WXrv2-00021J-S7 for pgsql-admin@arkaria.postgresql.org; Wed, 09 Apr 2014 12:47:56 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXrv2-00021D-1H for pgsql-admin@postgresql.org; Wed, 09 Apr 2014 12:47:56 +0000 Received: from webmail.zone.eu ([2a02:29e8:700:0:1::70]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXruy-00056m-PT for pgsql-admin@postgresql.org; Wed, 09 Apr 2014 12:47:55 +0000 Received: from webmail.zone.ee (webmail.zone.eu [IPv6:2a02:29e8:700:0:1::70]) by webmail.zone.eu (Postfix) with ESMTPA id 025F92402D1A; Wed, 9 Apr 2014 15:47:50 +0300 (EEST) Received: from [195.222.11.180] (Authenticated sender: spoon@planet.ee) by webmail.zone.ee ([217.146.65.71]) with HTTP; Wed, 09 Apr 2014 15:47:49 +0300 (EEST) From: "Viktor Juhanson" To: "Albe Laurenz" , "pgsql-admin@postgresql.org" Subject: Re: Update to 9.1.12 Date: Wed, 09 Apr 2014 15:47:49 +0300 References: <1397042974.1665600d@webmail.zone.ee> In-Reply-To: X-Mailer: DataZone Webmail/2.4 X-Priority: 3 Message-ID: <1397047669.d7d58e1e@webmail.zone.ee> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="--=_8431d650ee8266fb338ff1652737069b" X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ----=_8431d650ee8266fb338ff1652737069b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hello, =20 Thank you for your reply. =20 Could you please explain what does this command exactly do ? Will it = start VACUUM on all databases immidiatly=C2=A0 ? PGOPTIONS=3D'-o vacuum_freeze_table_age=3D0' vacuumdb =20 =20 Yes. That's what the release notes say. =20 One easy option is to run PGOPTIONS=3D'-o vacuum_freeze_table_age=3D0' vacuumdb =20 Yours, Laurenz Albe =20 --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin =20 ----=_8431d650ee8266fb338ff1652737069b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hello,

Thank you for your reply.

Could you please explain what does this command exactly do ? Will it start = VACUUM on all databases immidiatly  ?
PGOPTIONS=3D'-o vacuum_freeze_table_age=3D0' vacuumdb



Yes. That's what the release notes say.

One easy option is to run
PGOPTIONS=3D'-o vacuum_freeze_table_age=3D0' vacuumdb

Yours,
Laurenz Albe

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)<= br /> To make changes to your subscription:
http://www.postgres= ql.org/mailpref/pgsql-admin


----=_8431d650ee8266fb338ff1652737069b--