Re: [PATCH]-hash index improving - Mailing list pgsql-hackers

From Kenneth Marshall
Subject Re: [PATCH]-hash index improving
Date
Msg-id 20080718205800.GX337@it.is.rice.edu
Whole thread Raw
In response to Re: [PATCH]-hash index improving  (Kenneth Marshall <ktm@rice.edu>)
Responses Re: [PATCH]-hash index improving  ("Xiao Meng" <mx.cogito@gmail.com>)
List pgsql-hackers
FYI,

I just patched the fill-factor calculation and re-ran my test.
The index size dropped from 513M to 43M which is the same disk
footprint as the corresponding btree index.

Have a nice weekend.
Ken

On Fri, Jul 18, 2008 at 12:23:14PM -0500, Kenneth Marshall wrote:
> I just ran my original 16M word test case against the patched
> version, and like Tom noted below, the tuples per bucket
> calculation is wrong which results in identical index sizes
> for both the original version and the hash-value-only version.
> 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] WIP: executor_hook for pg_stat_statements
Next
From: Tom Lane
Date:
Subject: Re: temp table problem