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

Long count(*) time

From: "David Monarchi" <david(dot)e(dot)monarchi(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Long count(*) time
Date: 2007-09-25 20:02:49
Message-ID: eea51fdb0709251302x3e4deb43tbdf255895059e5ab@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello -

I'm running PG 8.2 on an 8-processor 16G Unix machine.  The machine is
dedicated to the db, and only 5 threads/processors are busy.  The following
query takes 70 seconds to execute.
     select count(*) from url_list_url;
There are 64,219,173 rows in the table.  The table consists of an integer
field and a text field.  The average length of the text field is 50
characters.  There are btree indexes on both fields.  The integer field is
the key.

70 seconds seems to be a long time for this kind of query.  Is this normal?

Thanks.

David

Responses

pgsql-novice by date

Next:From: Jon SimeDate: 2007-09-25 20:35:30
Subject: Re: Long count(*) time
Previous:From: Rajaram JDate: 2007-09-25 13:09:00
Subject: Re: Messages on my console.

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