From: Anibal David Acosta <aa@devshock.com>
To: pgsql-performance@postgresql.org
Subject: auto vacuum, not working?
Date: Fri, 13 Jan 2012 09:08:36 -0300
Message-ID: <000301ccd1ec$167ab7d0$43702770$@devshock.com> (raw)
Hi,
yesterday I delete about 200 million rows of a table (about 150GB of data),
after delete completes the autovacuum process start.
The autovacuum is running for about 11 hours but no space is released
Autovacuum parameters are with default values in postgresql.conf
The postgres version is 9.0.3
The pg activity reports:
select (now()-query_start) as duration, waiting, current_query from
pg_stat_activity where current_query ilike '%auto%'
10:42:19.829 f "autovacuum: VACUUM ANALYZE
public.myTable"
How can I release the space used by deleted rows? Without block the table.
Thanks!
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-performance@postgresql.org
Cc: aa@devshock.com
Subject: Re: auto vacuum, not working?
In-Reply-To: <000301ccd1ec$167ab7d0$43702770$@devshock.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