Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 25 Sep 2007 14:02:49 -0600
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
- Follow-Ups:
- Re: Long count(*) time
- From: Michael Cochez
- Re: Long count(*) time
- From: Richard Broersma Jr
- Re: Long count(*) time
- From: Jon Sime
- Re: Long count(*) time
- Prev by Date: Re: Messages on my console.
- Next by Date: Re: Long count(*) time
- Previous by thread: pg_hba.conf not right
- Next by thread: Re: Long count(*) time
- Indexes: