Re: hash index improving v3
От | Simon Riggs |
---|---|
Тема | Re: hash index improving v3 |
Дата | |
Msg-id | 1220494002.4371.813.camel@ebony.2ndQuadrant обсуждение исходный текст |
Ответ на | hash index improving v3 ("Xiao Meng" <mx.cogito@gmail.com>) |
Ответы |
Re: hash index improving v3
Re: hash index improving v3 |
Список | pgsql-patches |
On Mon, 2008-08-18 at 09:46 +0800, Xiao Meng wrote: > 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. You don't give the text of the query used to do these performance tests, so I can't validate your test results. Right now it seems strange that the index is larger than a btree, yet the performance tests show that 3 times as much I/O was used accessing the btree. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support
В списке pgsql-patches по дате отправления: