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 Zeugswetter Andreas OSB SD
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 E1539E0ED7043848906A8FF995BDA57902EB11CB@m0143.s-mxs.net
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)  (mx <mx.cogito@gmail.com>)
Responses Re: [GSoC] (Is it OK to choose items without % mark in theToDoList) && (is it an acceptable idea to build index on Flash Disk)
List pgsql-hackers
> So, I finally decide to focus on the project idea of improving hash
> index now. It's more valuable , and also challenging.
>
> Any suggestion about the project idea of improving hash index?

Imho one thing to look into is the storage. I do not see any real value
in storing the key itself (especially longer keys) in the hash buckets.
Instead store the hash value only (or not even that) and mark the index
lossy (recheck the key in the heap).

Andreas


pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: Integer datetimes
Next
From: Alvaro Herrera
Date:
Subject: Re: Minor bug in src/port/rint.c