Postgres Pro
Downloads
Home   >   mailing lists

Re: gprof SELECT COUNT(*) results - Mailing list pgsql-hackers

From Qingqing Zhou
Subject Re: gprof SELECT COUNT(*) results
Date
Msg-id dm95dp$2d4k$1@news.hub.org
Whole thread Raw
In response to gprof SELECT COUNT(*) results  (Qingqing Zhou <zhouqq@cs.toronto.edu>)
Responses Re: gprof SELECT COUNT(*) results  (Simon Riggs <simon@2ndquadrant.com>)
Re: gprof SELECT COUNT(*) results  ("Luke Lonergan" <llonergan@greenplum.com>)
List pgsql-hackers
Tree view 
"Tom Lane" <tgl@sss.pgh.pa.us> wrote
>
> I plan to take a look at it soon.
>

"Stand corrected"[Merlin]! In-memory "SELECT COUNT(*)" doubles the 
performance due to my test.

- before -
1.56 s

- now -
0.72 s

Regards,
Qingqing

pgsql-hackers by date:

Previous
From: Dennis Bjorklund
Date:
Subject: Re: SHOW ALL output too wide
Next
From: Peter Eisentraut
Date:
Subject: Re: PL/php in pg_pltemplate