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

count(*) slow on large tables

From: Dror Matalon <dror(at)zapatec(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: count(*) slow on large tables
Date: 2003-10-02 19:15:47
Message-ID: 20031002191547.GZ87525@rlx11.zapatec.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
Hi,

I have a somewhat large table, 3 million rows, 1 Gig on disk,  and growing. Doing a
count(*) takes around 40 seconds.

Looks like the count(*) fetches the table from disk and goes through it.
Made me wonder, why the optimizer doesn't just choose the smallest index
which in my case is around 60 Megs and goes through it, which it could
do in a fraction of the time.

Dror


-- 
Dror Matalon
Zapatec Inc 
1700 MLK Way
Berkeley, CA 94709
http://www.zapatec.com

Responses

pgsql-performance by date

Next:From: scott.marloweDate: 2003-10-02 19:34:16
Subject: further testing on IDE drives
Previous:From: Bill MoranDate: 2003-10-02 19:00:19
Subject: Re: low cardinality column

pgsql-hackers by date

Next:From: Tomasz MyrtaDate: 2003-10-02 19:36:42
Subject: Re: count(*) slow on large tables
Previous:From: Bruno Wolff IIIDate: 2003-10-02 19:15:33
Subject: Re: Thoughts on maintaining 7.3

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