Re: [GENERAL] table size is not changed

2010-02-03 Thread Scott Marlowe
On Wed, Feb 3, 2010 at 2:43 AM, AI Rumman wrote: > I deleted 7 rows from a table and then execute > vacuum analyze . > > 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.h

Re: [GENERAL] table size is not changed

2010-02-03 Thread Grzegorz Jaƛkiewicz
try reindexing table. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] table size is not changed

2010-02-03 Thread AI Rumman
I deleted 7 rows from a table and then execute vacuum analyze . But table size not yet changed. I am using Postgresql 8.1. Could anyone please tell me what the problem is?