Skip site navigation (1) Skip section navigation (2)

Re: auto vacuum, not working?

From: Mario Weilguni <roadrunner6(at)gmx(dot)at>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: auto vacuum, not working?
Date: 2012-01-13 14:26:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Am 13.01.2012 13:08, schrieb Anibal David Acosta:
> 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!

vacuum does not reclaim space, just marks tuples dead. You need vacuum full.

In response to


pgsql-performance by date

Next:From: Kevin GrittnerDate: 2012-01-13 14:50:21
Subject: Re: auto vacuum, not working?
Previous:From: Anibal David AcostaDate: 2012-01-13 12:08:36
Subject: auto vacuum, not working?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group