Re: gprof SELECT COUNT(*) results

On Sat, 2005-11-26 at 03:13 -0500, Qingqing Zhou wrote:
> "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
> 

...and for emphasis: this optimization of SeqScans is not possible with
any other database system, so its a big win for PostgreSQL.

Best Regards, Simon Riggs