Home > mailing lists

Re: table size is not changed - Mailing list pgsql-general

From	Scott Marlowe
Subject	Re: table size is not changed
Date	February 3, 2010 08:49:23
Msg-id	dcc563d11002030148k6f0cb02fu190fc7d3cf6df163@mail.gmail.com Whole thread Raw
In response to	table size is not changed (AI Rumman <rummandba@gmail.com>)
List	pgsql-general

Tree view

On Wed, Feb 3, 2010 at 2:43 AM, AI Rumman <rummandba@gmail.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.

pgsql-general by date:

From: Grzegorz Jaśkiewicz
Date: 03 February 2010, 08:47:57
Subject: Re: table size is not changed

From: Alban Hertroys
Date: 03 February 2010, 11:08:33
Subject: Re: Is it necessary to have index for child table in following case?

Re: table size is not changed - Mailing list pgsql-general

Previous

Next