Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id EBEAB632DF0
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun, 18 Apr 2010 07:36:06 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 28081-01 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun, 18 Apr 2010 10:35:56 +0000 (UTC)
X-Greylist: delayed 00:19:37.468953 by SQLgrey-1.7.6
Received: from mail-gy0-f174.google.com (mail-gy0-f174.google.com
	[209.85.160.174])
	by mail.postgresql.org (Postfix) with ESMTP id 6D294632AF9
	for <pgsql-admin@postgresql.org>; Sun, 18 Apr 2010 07:35:56 -0300 (ADT)
Received: by gyg13 with SMTP id 13so2122151gyg.19
	for <pgsql-admin@postgresql.org>; Sun, 18 Apr 2010 03:35:55 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.151.44.17 with HTTP; Sun, 18 Apr 2010 03:09:23 -0700 (PDT)
Date: Sun, 18 Apr 2010 17:09:23 +0700
Received: by 10.150.56.41 with SMTP id e41mr4299915yba.348.1271585363548;
 Sun,
	18 Apr 2010 03:09:23 -0700 (PDT)
Message-ID: <q2lfdb87dba1004180309t84751ea7q8c534599c49f5c8c@mail.gmail.com>
Subject: Setting Auto Vacuum from PGAdmin
From: Feris Thia <milis.database@phi-integration.com>
To: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=000e0cd71f66e55a5504848009b2
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201004/246
X-Sequence-Number: 34340

--000e0cd71f66e55a5504848009b2
Content-Type: text/plain; charset=ISO-8859-1

Hi Everyone,

I've just maintain my postgresql server 8.1 which has a database of 470 GB
in size. What I mean by maintenance is to vacuum analyze it. And now it
looks faster to accesss every tables in that database.

What I want to do is to set autovacuum for some of the tables, which
configuration dialog is available in PGAdmin. Does it save to do so ? And is
it permanently configured ? I dare not try it right now before I've got some
advice from experienced administrator.

Thanks,

Feris

--000e0cd71f66e55a5504848009b2
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Everyone,<div><br></div><div>I&#39;ve just maintain my postgresql server=
 8.1 which has a database of 470 GB in size. What I mean by maintenance is =
to vacuum analyze it. And now it looks faster to accesss every tables in th=
at database.</div>
<div><br></div><div>What I want to do is to set autovacuum for some of the =
tables, which configuration dialog is available in PGAdmin. Does it save to=
 do so ? And is it permanently configured ? I dare not try it right now bef=
ore I&#39;ve got some advice from experienced administrator.</div>
<div><br></div><div>Thanks,</div><div><br></div><div>Feris</div>

--000e0cd71f66e55a5504848009b2--