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 ?
And if you find any bugs in pgAdmin, don't forget to report them.
In response to
pgsql-admin by date
|Next:||From: Khangelani Gama||Date: 2010-04-19 07:17:54|
|Subject: PANIC: read of clog file 3165, offset 0 failed: Success|
|Previous:||From: Feris Thia||Date: 2010-04-18 10:09:23|
|Subject: Setting Auto Vacuum from PGAdmin|