On 9/24/07, Gábor Farkas <gabor(at)nekomancer(dot)net> 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.
In response to
pgsql-performance by date
|Next:||From: Heikki Linnakangas||Date: 2007-09-24 14:30:09|
|Subject: Re: select count(*) performance (vacuum did not help)|
|Previous:||From: brauagustin-susc||Date: 2007-09-24 14:16:38|
|Subject: Re: Low CPU Usage|