[postgis-devel] Strange result about spatial indexes?

Tom Lane tgl at sss.pgh.pa.us
Fri Aug 14 20:16:16 PDT 2009


Paul Ramsey <pramsey at opengeo.org> writes:
> Incidentally, I don't think switching our storage type is the
> solution, it is treating the symptom (time spent in gist consistent)
> rather than the disease (so very many calls into gist consistent).

As far as I can tell from the profile, the time is being spent in
accessing index entries.  How is heap_tuple_untoast_attr_slice involved
at all?

			regards, tom lane



More information about the postgis-devel mailing list