From: Greg Smith <greg@2ndQuadrant.com>
To: pgsql-performance@postgresql.org
Subject: Re: auto vacuum, not working?
Date: Sun, 15 Jan 2012 07:09:50 -0500
Message-ID: <4F12C20E.7080400@2ndQuadrant.com> (raw)
In-Reply-To: <000301ccd1ec$167ab7d0$43702770$@devshock.com>
References: <000301ccd1ec$167ab7d0$43702770$@devshock.com>
On 01/13/2012 07:08 AM, Anibal David Acosta wrote:
>
> How can I release the space used by deleted rows? Without block the table.
>
>
The database can only reduce the size tables by returning space to the
operating system in one situation: there is free space at the very end
of the table. In that case, if it's possible to get a brief exclusive
lock on the table, it can shrink in size.
There are some programs available that reorganize table for goals like
this, without having any long-lasting locks on the tables. pg_reorg is
the most popular example: http://pgfoundry.org/projects/reorg/
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com
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: greg@2ndQuadrant.com
Subject: Re: auto vacuum, not working?
In-Reply-To: <4F12C20E.7080400@2ndQuadrant.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