Re: [PERFORM] disk space usage unexpected

again, I have adjusted the autovacuum parameters, to make it keep up with the updates. Not sure if this is the right way to solve this kind of problem. Best Regards Rose Zhou _ From: Ben Chobot [mailto:be...@silentmedia.com] Sent: 17 February 2010 13:34 To: Rose Zhou Cc

Re: [PERFORM] disk space usage unexpected

Thanks Ben: I will adjust the auto vacuum parameters. It is on now, maybe not frequently enough. How to get the disk space back to OS? Will a Vacuum Full Verbose get the disk space back to OS? Best Regards Rose Zhou _ From: Ben Chobot [mailto:be...@silentmedia.com] Sent

[PERFORM] Auto Vacuum out of memory

--- # - Previous PostgreSQL Versions - #add_missing_from = off #array_nulls = on #backslash_quote = safe_encoding# on, off, or safe_encoding #default_with_oids = off #escape_string_warning = on #regex_flavor = advanced# advanced, extended, or basic #sql_

[PERFORM] disk space usage unexpected

PGDATA/base. This caused the disk space quickly used up. Is this expected? Thanks for any information Best Regards Rose Zhou -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance