Just do a search for heap_beginscan() and look at all those system table
heap scans. Clearly, for large installations, we should be doing index
scans.
Seems like we should consider identifying all of the needed system
indexes. I can add all indexes at one time, and people can go around
and modify heap scans to index scans with heap_fetches of the tid if
required.
Comments?
--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026