Hi, On 10/19/22 8:19 PM, Andres Freund wrote:
Hi, Here's a largely unordered list of ideas. I'm not planning to work on them myself, but thought it'd nevertheless be useful to have them memorialized somewhere.
Thanks for sharing this list of ideas!
2) Split index and table statistics into different types of stats We track both types of statistics in the same format and rename column in views etc to make them somewhat sensible. A number of the "columns" in index stats are currently unused. If we split the stats for indexes and relations we can have reasonable names for the fields, shrink the current memory usage by halfing the set of fields we keep for indexes, and extend the stats in a more targeted fashion.
I started to work on this. I should be able to provide a patch attempt in the next couple of weeks. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com
