This would require capture of information beyond what I was thinking about in terms of schema. Do you think we need to capture just index type, or something more? Do you propose that we capture the pg_* metadata related to every object referenced in the plan, every object related to every table in the query, or everything in the entire database?
>>> Josh Berkus <josh@agliodbs.com> >>> [smip] the only way you're going analyze index costing by type of index is if the index name is stored somewhere (db_object) so that it can be matched to its characteristics. [snip] ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings