Skip site navigation (1) Skip section navigation (2)

hash index improving v3

From: "Xiao Meng" <mx(dot)cogito(at)gmail(dot)com>
To: pgsql-patches(at)postgresql(dot)org, "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
Subject: hash index improving v3
Date: 2008-08-18 01:46:06
Message-ID: ded849dd0808171846g2c6c65adub942bd2510a6c94f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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(dot)cogito(at)gmail(dot)com
MSN: cnEnder(at)live(dot)com
http://xiaomeng.yo2.cn

Attachment: hash-v3.patch
Description: text/x-diff (21.3 KB)

Responses

pgsql-hackers by date

Next:From: Josh BerkusDate: 2008-08-18 03:23:07
Subject: Re: Overhauling GUCS
Previous:From: Robert HaasDate: 2008-08-18 00:07:55
Subject: Re: proposal sql: labeled function params

pgsql-patches by date

Next:From: Tatsuo IshiiDate: 2008-08-18 07:38:52
Subject: WITH RECURSIVE patches 0818
Previous:From: Simon RiggsDate: 2008-08-07 16:05:14
Subject: Re: Infrastructure changes for recovery

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group