On Wed, Apr 20, 2022 at 1:03 AM Kyotaro Horiguchi
wrote:
>
> The reason for the 2 hits of Xact SLRU is that once for visibility
> (MVCC) check and another for commit.
>
>
Makes sense. Thanks. Now, is the lack of such a detail when looking at
pg_stat_slru (for this and the other 6 named caches)
At Tue, 19 Apr 2022 17:51:24 -0700, "David G. Johnston"
wrote in
> On Tue, Apr 19, 2022 at 4:36 PM Nathan Bossart
> wrote:
>
> > On Tue, Apr 19, 2022 at 04:21:21PM -0700, David G. Johnston wrote:
> > > I've done this four times in a row and while the number of dirty buffers
> > > shown each
On Tue, Apr 19, 2022 at 4:36 PM Nathan Bossart
wrote:
> On Tue, Apr 19, 2022 at 04:21:21PM -0700, David G. Johnston wrote:
> > I've done this four times in a row and while the number of dirty buffers
> > shown each time vary (see below) I see that "wrote N buffers" is always
> > exactly one more
On Tue, Apr 19, 2022 at 04:21:21PM -0700, David G. Johnston wrote:
> I've done this four times in a row and while the number of dirty buffers
> shown each time vary (see below) I see that "wrote N buffers" is always
> exactly one more than the total count of dirty buffers. I'm just curious
> if
view bc is just a joining wrapper around pg_buffercache.
regression=# select datname, relname, count(*), sum(count(*)) over () AS
total from bc where isdirty group by datname, relname;
datname | relname | count | total
-+-+---+---
(0 rows)
regression=# update tenk1 set