Skip site navigation (1) Skip section navigation (2)

Re: select count(*) performance (vacuum did not help)

From: "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
To: Gábor Farkas <gabor(at)nekomancer(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: select count(*) performance (vacuum did not help)
Date: 2007-09-24 14:23:49
Message-ID: 2e78013d0709240723w7dc0379ai7f8b323f45439b15@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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.

Thanks,
Pavan

-- 
Pavan Deolasee
EnterpriseDB     http://www.enterprisedb.com

In response to

pgsql-performance by date

Next:From: Heikki LinnakangasDate: 2007-09-24 14:30:09
Subject: Re: select count(*) performance (vacuum did not help)
Previous:From: brauagustin-suscDate: 2007-09-24 14:16:38
Subject: Re: Low CPU Usage

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group