Re: table size is not changed

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: table size is not changed
Date: 2010-02-03 09:48:42
Message-ID: dcc563d11002030148k6f0cb02fu190fc7d3cf6df163@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Feb 3, 2010 at 2:43 AM, AI Rumman <rummandba(at)gmail(dot)com> wrote:
> I deleted 70000 rows from a table and then execute
> vacuum analyze <table>.
>
> But table size not yet changed.
>
> I am using Postgresql 8.1.
>
> Could anyone please tell me what the problem is?

http://www.postgresql.org/docs/8.1/static/maintenance.html#VACUUM-FOR-SPACE-RECOVERY

explains it pretty well.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2010-02-03 12:06:15 Re: Is it necessary to have index for child table in following case?
Previous Message Grzegorz Jaśkiewicz 2010-02-03 09:47:41 Re: table size is not changed