Postgres Pro
Downloads
Home   >   mailing lists

Setting Auto Vacuum from PGAdmin - Mailing list pgsql-admin

From Feris Thia
Subject Setting Auto Vacuum from PGAdmin
Date
Msg-id q2lfdb87dba1004180309t84751ea7q8c534599c49f5c8c@mail.gmail.com
Whole thread Raw
Responses Re: Setting Auto Vacuum from PGAdmin  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Samuel Stearns
Date:
Subject: Re: FW: More than 1 pg_database Entry for Database - Thread #2
Next
From: Guillaume Lelarge
Date:
Subject: Re: Setting Auto Vacuum from PGAdmin