Hi, While going through the mail chain on relation, plan and catalogue caching [1], I'm thinking on the lines that is there a way to know the current relation, plan and catalogue cache sizes? If there is a way already, please ignore this and it would be grateful if someone point me to that.
Posting this here as I felt it's relevant. If there is no such way to know the cache sizes and other info such as statistics, number of entries, cache misses, hits etc. can the approach discussed here be applied? If the user knows the cache statistics and other information, may be we can allow user to take appropriate actions such as allowing him to delete few entries through a command or some other way. I'm sorry, If I'm diverting the topic being discussed in this mail thread, please ignore if it is irrelevant. [1] - https://www.postgresql.org/message-id/flat/20161219.201505.11562604.horiguchi.kyotaro%40lab.ntt.co.jp With Regards, Bharath Rupireddy. EnterpriseDB: http://www.enterprisedb.com