Postgres Pro
Downloads
Home   >   mailing lists

Re: why does count take so long? - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: why does count take so long?
Date
Msg-id 3F5D1205.6030703@selectacast.net
Whole thread Raw
In response to Re: why does count take so long?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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%

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: About GPL and proprietary software
Next
From: Greg Stark
Date:
Subject: Another pimple on the type system