Re: shared memory stats ideas

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