From: Feris Thia <milis.database@phi-integration.com>
To: pgsql-admin@postgresql.org
Subject: Setting Auto Vacuum from PGAdmin
Date: Sun, 18 Apr 2010 17:09:23 +0700
Message-ID: <q2lfdb87dba1004180309t84751ea7q8c534599c49f5c8c@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: milis.database@phi-integration.com
Subject: Re: Setting Auto Vacuum from PGAdmin
In-Reply-To: <q2lfdb87dba1004180309t84751ea7q8c534599c49f5c8c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox