Re: B-Heaps - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: B-Heaps
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.)


pgsql-performance by date:

From: Yeb Havinga
Subject: Re: B-Heaps
From: Tom Lane
Subject: Re: B-Heaps