Re: [GSoC] (Is it OK to choose items without % mark in theToDoList) && (is it an acceptable idea to build index on Flash Disk) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GSoC] (Is it OK to choose items without % mark in theToDoList) && (is it an acceptable idea to build index on Flash Disk)
Date
Msg-id 5980.1206377560@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GSoC] (Is it OK to choose items without % mark in theToDoList) && (is it an acceptable idea to build index on Flash Disk)  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
List pgsql-hackers
"Heikki Linnakangas" <heikki@enterprisedb.com> writes:
> mx wrote:
>> By the way, I'm writing proposal for multi-column hash now.

> The biggest problem with the hash index is currently that there's no 
> significant performance over b-tree. If you want to work on hash 
> indexes, I would suggest doing benchmarking and looking at ways to 
> improve performance, before spending time on making it multi-column 
> capable.

Quite.  There are already some people investigating that, but maybe you
could join forces with them.

> And missing WAL logging is a big issue as well.

Yeah, but again there seems little point in doing that work until/unless
there is a demonstrable performance use-case for hash indexes.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Proposal: new ereport option "errdetail_log"
Next
From: Alvaro Herrera
Date:
Subject: Re: gcc 4.3 breaks ContribCheck in 8.2 and older.