Re: B-Heaps - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: B-Heaps
Date
Msg-id 4C1B783602000025000325CE@gw.wicourts.gov
Whole thread Raw
In response to Re: B-Heaps  (Yeb Havinga)
Responses Re: B-Heaps  (Yeb Havinga)
List pgsql-performance
Yeb Havinga <> wrote:

> concerning gist indexes:
>
> 1) with larger block sizes and hence, larger # entries per gist
> page, results in more generic keys of those pages. This in turn
> results in a greater number of hits, when the index is queried, so
> a larger part of the index is scanned. NB this has nothing to do
> with caching / cache sizes; it holds for every IO model. Tests
> performed by me showed performance improvements of over 200%.
> Since then implementing a speedup has been on my 'want to do
> list'.

As I recall, the better performance in your tests was with *smaller*
GiST pages, right?  (The above didn't seem entirely clear on that.)

-Kevin

pgsql-performance by date:

Previous
From: Yeb Havinga
Date:
Subject: Re: B-Heaps
Next
From: Tom Lane
Date:
Subject: Re: B-Heaps