Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 5A6312EE4E2 for ; Fri, 13 Jan 2012 08:08:54 -0400 (AST) Received: from mail-gy0-f174.google.com ([209.85.160.174]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RlfwC-0007mS-Gs for pgsql-performance@postgresql.org; Fri, 13 Jan 2012 12:08:53 +0000 Received: by ghbg16 with SMTP id g16so814938ghb.19 for ; Fri, 13 Jan 2012 04:08:39 -0800 (PST) Received: by 10.236.154.5 with SMTP id g5mr1095476yhk.63.1326456519814; Fri, 13 Jan 2012 04:08:39 -0800 (PST) Received: from AnibalVAIO (host-20-79.b4.cmm.com.py. [200.26.179.79]) by mx.google.com with ESMTPS id j11sm22662027anl.8.2012.01.13.04.08.36 (version=TLSv1/SSLv3 cipher=OTHER); Fri, 13 Jan 2012 04:08:38 -0800 (PST) From: "Anibal David Acosta" To: Subject: auto vacuum, not working? Date: Fri, 13 Jan 2012 09:08:36 -0300 Message-ID: <000301ccd1ec$167ab7d0$43702770$@devshock.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0004_01CCD1D2.F12F0670" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AczR6oeSnLY+nCiPTIuZIHZpqQLneg== Content-Language: es-py X-Pg-Spam-Score: -1.2 (-) X-Archive-Number: 201201/41 X-Sequence-Number: 46054 This is a multipart message in MIME format. ------=_NextPart_000_0004_01CCD1D2.F12F0670 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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! ------=_NextPart_000_0004_01CCD1D2.F12F0670 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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!

 

 

 

------=_NextPart_000_0004_01CCD1D2.F12F0670--