Re: Really really slow select count(*)

From: felix <crucialfelix(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Really really slow select count(*)
Date: 2011-02-04 17:44:52
Message-ID: AANLkTi=3n_W-OFVuVHx3Tthn_KiMN42BturJUS5BuWVz@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

vacuumdb -a -v -z -U postgres -W &> vacuum.log

that's all, isn't it ?

it did each db

8.3 in case that matters

the very end:

There were 0 unused item pointers.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: analyzing "public.seo_partnerlinkcategory"
INFO: "seo_partnerlinkcategory": scanned 0 of 0 pages, containing 0 live
rows and 0 dead rows; 0 rows in sample, 0 estimated total rows

On Fri, Feb 4, 2011 at 6:40 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:

>
> > I tried it with all databases too
>
> I believe you have to run it on the whole db to get that output.
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Shaun Thomas 2011-02-04 17:45:22 Re: Really really slow select count(*)
Previous Message Scott Marlowe 2011-02-04 17:40:42 Re: Really really slow select count(*)