| From: | "Drouvot, Bertrand" <bertranddrouvot(dot)pg(at)gmail(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers(at)postgresql(dot)org |
| Cc: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, Lukas Fittl <lukas(at)fittl(dot)com>, Greg Stark <stark(at)mit(dot)edu>, Peter Geoghegan <pg(at)bowt(dot)ie>, Melanie Plageman <melanieplageman(at)gmail(dot)com>, "Drouvot, Bertrand" <bdrouvot(at)amazon(dot)com> |
| Subject: | Re: shared memory stats ideas |
| Date: | 2022-10-20 07:17:44 |
| Message-ID: | dc07a267-86b4-0c87-70f9-4f11cb079ab6@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | houzj.fnst@fujitsu.com | 2022-10-20 07:34:31 | RE: list of TransactionIds |
| Previous Message | wangw.fnst@fujitsu.com | 2022-10-20 07:08:36 | RE: Logical replication timeout problem |