Can anyone provide a brief overview of how to go about interpreting
the information generated by the statistics collector? I've looked
around and can't find old mailing list messages or anything in the
manual beyond the basics of how to query the statistics.
Cache hit rates are easy to compute, but is this useful beyond
knowing if Postgres has enough buffers?
Can anything useful be gleaned from looking at idx_scan /
idx_tup_read / idx_tup_fetch?
--
Steve Madsen <steve@xxxxxxxxxxxxxxxxxxxxx>
Light Year Software, LLC http://lightyearsoftware.com
ZingLists: Stay organized, and share lists online. http://zinglists.com
---------------------------(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
