From: | "Luke Lonergan" <llonergan(at)greenplum(dot)com> |
---|---|
To: | "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>, pgsql-hackers(at)postgresql(dot)org |
Cc: | "Ayush Parashar" <aparashar(at)greenplum(dot)com> |
Subject: | Re: gprof SELECT COUNT(*) results |
Date: | 2005-11-26 20:19:36 |
Message-ID: | BFAE0358.147EA%llonergan@greenplum.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2005-11-26 22:38:23 | Windows installation notes |
Previous Message | Andrew Dunstan | 2005-11-26 20:04:22 | Re: PL/php in pg_pltemplate |