| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Kenneth Marshall <ktm(at)rice(dot)edu> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: [PATCHES] updated hash functions for postgresql v1 |
| Date: | 2009-01-09 22:00:39 |
| Message-ID: | 1231538439.12384.6.camel@dell.linuxdev.us.dell.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 2009-01-09 at 14:29 -0600, Kenneth Marshall wrote:
> Jeff,
>
> Thanks for the review. I would not really expect any differences in hash
> index build times other than normal noise variances. The most definitive
> benchmark that I have seen was done with my original patch submission
> in March posted by Luke of Greenplum:
>
> "We just applied this and saw a 5 percent speedup on a hash aggregation
> query with four columns in a 'group by' clause run against a single
> TPC-H table."
>
> I wonder if they would be willing to re-run their test? Thanks again.
Separating mix() and final() should have some performance benefit,
right?
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2009-01-09 22:22:55 | Re: Buffer pool statistics in Explain Analyze |
| Previous Message | Hiroshi Inoue | 2009-01-09 21:45:46 | Re: Re: [COMMITTERS] pgsql: Explicitly bind gettext() to the UTF8 locale when in use. |