Re: gprof SELECT COUNT(*) results

["Luke Lonergan" <llonergan(at)greenplum(dot)com>]

Title: Re: [HACKERS] gprof SELECT COUNT(*) results

Nice job Qingqing and Tom!

The improved executor / agg performance will likely help BI / data warehouse customers a lot.  I’ll get some DBT-3 results to substantiate as soon as we can.

- Luke


On 11/26/05 12:13 AM, "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> wrote:

> "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>        message can get through to the mailing list cleanly