On Wed, Feb 3, 2010 at 2:43 AM, AI Rumman <rummandba@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
