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 <ktm@rice.edu>)
Ответы Re: [PATCHES] updated hash functions for postgresql v1  (Kenneth Marshall <ktm@rice.edu>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Explicitly bind gettext() to the UTF8 locale when in use.
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Buffer pool statistics in Explain Analyze