Re: Really really slow select count(*) - Mailing list pgsql-performance

From felix
Subject Re: Really really slow select count(*)
Date
Msg-id AANLkTi=3n_W-OFVuVHx3Tthn_KiMN42BturJUS5BuWVz@mail.gmail.com
Whole thread Raw
In response to Re: Really really slow select count(*)  (Scott Marlowe <scott.marlowe@gmail.com>)
List 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.marlowe@gmail.com> wrote:

> I tried it with all databases too

I believe you have to run it on the whole db to get that output.

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Really really slow select count(*)
Next
From: Shaun Thomas
Date:
Subject: Re: Really really slow select count(*)