Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 4E8BE63296B
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun, 18 Apr 2010 10:22:58 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 63112-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun, 18 Apr 2010 13:22:39 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sd-17937.dedibox.fr (sd-17937.dedibox.fr [88.191.100.74])
	by mail.postgresql.org (Postfix) with ESMTP id 9158B62F5D9
	for <pgsql-admin@postgresql.org>; Sun, 18 Apr 2010 10:22:47 -0300 (ADT)
Received: from [192.168.1.24] (240.173.82-79.rev.gaoland.net [79.82.173.240])
	by sd-17937.dedibox.fr (Postfix) with ESMTPA id 2ACE63B8F5;
	Sun, 18 Apr 2010 15:22:45 +0200 (CEST)
Message-ID: <4BCB07A1.9030607@lelarge.info>
Date: Sun, 18 Apr 2010 15:22:41 +0200
From: Guillaume Lelarge <guillaume@lelarge.info>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr;
	rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
To: Feris Thia <milis.database@phi-integration.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Setting Auto Vacuum from PGAdmin
References: <q2lfdb87dba1004180309t84751ea7q8c534599c49f5c8c@mail.gmail.com>
In-Reply-To: <q2lfdb87dba1004180309t84751ea7q8c534599c49f5c8c@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.95 tagged_above=-10 required=5 tests=AWL=0.950,
	BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201004/247
X-Sequence-Number: 34341

Hi,

Le 18/04/2010 12:09, Feris Thia a écrit :
> [...]
> 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.

Sure, use the table properties dialog to change the autovacuum settings
for each table.

> Does it save to do so ?

I suppose you mean safe? if so, sure, it is completely safe.

> And is it permanently configured ?

Yes.

And if you find any bugs in pgAdmin, don't forget to report them.


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com