Horton

Re: why does count take so long?

Joseph S <jks@selectacast.net>

View thread View on postgr.es
From: Joseph Shraibman <jks@selectacast.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@postgresql.org
Date: 2003-09-08T23:34:29Z
Lists: pgsql-general 
Tom Lane wrote:

> Unless Joseph's machine has a way better IO-to-CPU ratio than my little
> development machine, there's something odd about his numbers.
> 
> 			regards, tom lane
Doing some math:

81372.11 / 71542.53 : 1.1373949174008804
189865.81 / 163833.61 : 1.1588941365572059

So I have count() taking 14% over the seqscan, and you have 16%