table size is not changed

try reindexing table.

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.