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: 4F103F00.2080904@gmx.at (view raw or flat)
Thread:
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

Responses

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-2014 The PostgreSQL Global Development Group