On Wed, May 15, 2024 at 1:26 AM Dimitrios Apostolou <jimis@gmx.net> wrote:
Hello list,
what is the "background worker" in the pg_stat_io statistics view? I'm reading the documentation but can't figure this one out knowing that it is not autovacuum or bgwriter. And I'm not aware of any extension I might have with registered background worker.
Additionally, how can it be evictions > writes? I would expect every eviction to cause a write.
Finally about "hits", I understand they are reads found in shared_buffers, so they never registered into the "reads" counter. So is "reads" in pg_stat_io the equivalent to misses, i.e. the opposite of "hits", the read attempts not found in the shared_buffers, that needed to be fetched from the disk (or OS buffercache)?