hash index improving v3

Поиск
Список
Период
Сортировка
От Xiao Meng
Тема hash index improving v3
Дата
Msg-id ded849dd0808171846g2c6c65adub942bd2510a6c94f@mail.gmail.com
обсуждение исходный текст
Ответы Re: hash index improving v3  ("Xiao Meng" <mx.cogito@gmail.com>)
Re: hash index improving v3  (Simon Riggs <simon@2ndQuadrant.com>)
Re: hash index improving v3  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Список pgsql-patches
There's minor change against the previous one( http://archives.postgresql.org/pgsql-hackers/2008-07/msg01183.php ).
* merge branch master(Aug 16) into the patch
* clean code and make some comment
Performance result is here
http://wiki.postgresql.org/wiki/Gsoc08-hashindex


It seems hash index is a little better on index creation and selection.
But maybe  it's in the range of noise, I'm not sure.
I'd like to try it with a bigger dataset (e.g. table with 10GB) but there is not enough space in my computer.
Anyone interest can make a test on a bigger data set.

--
Best Regards,
Xiao Meng

DKERC, Harbin Institute of Technology, China
Gtalk: mx.cogito@gmail.com
MSN: cnEnder@live.com
http://xiaomeng.yo2.cn
Вложения

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: [HACKERS] get_relation_stats_hook()
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: WITH RECURSIVE patches 0818