Re: pg_stat_statements, write activity - Mailing list pgsql-admin

From Scott Ribe
Subject Re: pg_stat_statements, write activity
Date
Msg-id 4D3DD5A9-AB6C-4BE1-8F21-091B482C6B48@elevated-dev.com
Whole thread Raw
In response to Re: pg_stat_statements, write activity  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: pg_stat_statements, write activity
List pgsql-admin
> On May 16, 2025, at 1:37 PM, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> Sometimes, a backend writes a block to disk itself.  This might happen if a lot
> of cache pressure, but usually it happens when the table is extended with new
> blocks.

Ah, that's the piece I was missing!

Do the written blocks get counted as dirty first, or only as written?


pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: pg_stat_statements, write activity
Next
From: Edwin UY
Date:
Subject: PostgreSQL Load Testing