Yeb Havinga <yebhavinga@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
