Re: gprof SELECT COUNT(*) results

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
>
>

In response to

Browse pgsql-hackers by date

  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