table size is not changed

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: table size is not changed
Date: 2010-02-03 09:43:55
Message-ID: 2a7905441002030143q1bcd5b12m761c664b013a21e3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2010-02-03 09:47:41 Re: table size is not changed
Previous Message Florent THOMAS 2010-02-03 09:35:30 Re: Attribute a value to a record