Re: [PATCHES] updated hash functions for postgresql v1
От
Jeff Davis
Тема
Re: [PATCHES] updated hash functions for postgresql v1
Дата
Msg-id
1231538439.12384.6.camel@dell.linuxdev.us.dell.com
Ответ на
Re: [PATCHES] updated hash functions for postgresql v1 (Kenneth Marshall)
Список
Дерево обсуждения
Re: [PATCHES] updated hash functions for postgresql v1 Kenneth Marshall <ktm@rice.edu>
Re: [PATCHES] updated hash functions for postgresql v1 Jeff Davis <pgsql@j-davis.com>
Re: [PATCHES] updated hash functions for postgresql v1 Kenneth Marshall <ktm@rice.edu>
Re: [PATCHES] updated hash functions for postgresql v1 Jeff Davis <pgsql@j-davis.com>
Re: [PATCHES] updated hash functions for postgresql v1 Kenneth Marshall <ktm@rice.edu>
Re: [PATCHES] updated hash functions for postgresql v1 Jeff Davis <pgsql@j-davis.com>
Re: [PATCHES] updated hash functions for postgresql v1 Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] updated hash functions for postgresql v1 Jeff Davis <pgsql@j-davis.com>
Re: [PATCHES] updated hash functions for postgresql v1 Kenneth Marshall <ktm@rice.edu>
Re: [PATCHES] updated hash functions for postgresql v1 Kenneth Marshall <ktm@rice.edu>
Re: [PATCHES] updated hash functions for postgresql v1 Kenneth Marshall <ktm@rice.edu>
Re: [PATCHES] updated hash functions for postgresql v1 Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] updated hash functions for postgresql v1 Asko Oja <ascoja@gmail.com>
Re: [PATCHES] updated hash functions for postgresql v1 Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] updated hash functions for postgresql v1 Hannu Krosing <hannu@2ndQuadrant.com>
Re: [PATCHES] updated hash functions for postgresql v1 Jeff Davis <pgsql@j-davis.com>
Re: [PATCHES] updated hash functions for postgresql v1 Hannu Krosing <hannu@2ndQuadrant.com>
Re: [PATCHES] updated hash functions for postgresql v1 Peter Eisentraut <peter_e@gmx.net>
Re: [PATCHES] updated hash functions for postgresql v1 Hannu Krosing <hannu@2ndQuadrant.com>
Re: [PATCHES] updated hash functions for postgresql v1 Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] updated hash functions for postgresql v1 Peter Eisentraut <peter_e@gmx.net>
Re: [PATCHES] updated hash functions for postgresql v1 Hannu Krosing <hannu@2ndQuadrant.com>
Re: [PATCHES] updated hash functions for postgresql v1 Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] updated hash functions for postgresql v1 Hannu Krosing <hannu@2ndQuadrant.com>
Re: [PATCHES] updated hash functions for postgresql v1 Kenneth Marshall <ktm@rice.edu>
Re: [PATCHES] updated hash functions for postgresql v1 Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] updated hash functions for postgresql v1 Gregory Stark <stark@enterprisedb.com>
Re: [PATCHES] updated hash functions for postgresql v1 Jeff Davis <pgsql@j-davis.com>
Re: [PATCHES] updated hash functions for postgresql v1 Kenneth Marshall <ktm@rice.edu>
Re: [PATCHES] updated hash functions for postgresql v1 Alvaro Herrera <alvherre@commandprompt.com>
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
В списке pgsql-hackers по дате отправления
От: Hiroshi Inoue
Дата: