Tom, I also notice that the link I put in ages ago to Kornacker's thesis
is now defunct :(
(GiST indexes Introduction)
A quick search of Google Scholar finds it hosted on Oleg & Teodor's site.
http://scholar.google.com/scholar?hl=en&lr=&safe=off&q=Marcel+Kornacker+Access+Methods+for+Next-Generation+Database+Systems.&btnG=Search
Chris
Tom Lane wrote:
Log Message:
-----------
Clean up some obsolete statements about GiST indexes, and add a section
documenting GiST crash recovery procedures, as requested some time ago
by Teodor. (The GiST chapter doesn't seem quite the right place for
the latter, but I'm not sure what else to do with it.)
Modified Files:
--------------
pgsql/doc/src/sgml:
gist.sgml (r1.21 -> r1.22)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/gist.sgml.diff?r1=1.21&r2=1.22)
indices.sgml (r1.52 -> r1.53)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/indices.sgml.diff?r1=1.52&r2=1.53)
mvcc.sgml (r2.51 -> r2.52)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/mvcc.sgml.diff?r1=2.51&r2=2.52)
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match