On Fri, Oct 21, 2022 at 2:26 AM Kyotaro Horiguchi
wrote:
> Stickier buffers for index pages seems to be related. I haven't see it
> even get started, though. But this might be able be an additional
> reason for starting it.
Maybe, but FWIW I think that that will mostly just need to distinguish
l
Hi,
On 10/20/22 9:17 AM, Drouvot, Bertrand wrote:
On 10/19/22 8:19 PM, Andres Freund wrote:
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 "co
Thanks for the nice list.
At Wed, 19 Oct 2022 12:37:30 -0700, Peter Geoghegan wrote in
> On Wed, Oct 19, 2022 at 11:19 AM Andres Freund wrote:
> > We e.g. currently can't track the number of blocks written out in a
> > relation,
> > because we don't have a Relation at that point. Nor can't we
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 i
On Wed, Oct 19, 2022 at 11:19 AM Andres Freund wrote:
> We e.g. currently can't track the number of blocks written out in a relation,
> because we don't have a Relation at that point. Nor can't we really get hold
> of one, as the writeback can happen in a different database without access to
> pg_
Hi,
shortly after shared memory stats went in I had a conversation with Lukas
about what it'd enable us going forward. I also chatted with Peter about
autovacuum related stats. I started to write an email, but then somehow lost
the draft and couldn't bring myself to start from scratch.
Here's a
