Re: why does count take so long?

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: why does count take so long?
Date: 2003-09-08 23:34:29
Message-ID: 3F5D1205.6030703@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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%

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Mayer 2003-09-08 23:46:13 Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Previous Message Ron Mayer 2003-09-08 23:05:38 Re: [PATCHES] ISO 8601 "Time Intervals" of the "format with time-unit designators"