On 9/24/07, Gábor Farkas <[EMAIL PROTECTED]> wrote: > > > INFO: "main_activity": found 41001 removable, 11672 nonremovable row > versions in 160888 pages > DETAIL: 0 dead row versions cannot be removed yet. > There were 14029978 unused item pointers. > 0 pages are entirely empty. > CPU 5.53s/1.71u sec elapsed 227.35 sec. > INFO: analyzing "public.main_activity" > INFO: "main_activity": 160888 pages, 4500 rows sampled, 4594 estimated > total rows > > Looking at the number of rows vs number of pages, ISTM that VACUUM FULL should help you.
Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com