Re: Understanding pg_stat_io.evictions - Mailing list pgsql-general

From Daniel Westermann (DWE)
Subject Re: Understanding pg_stat_io.evictions
Date
Msg-id GV0P278MB0419D67F8EA158F25D4D8E29D205A@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: Understanding pg_stat_io.evictions  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
List pgsql-general
>> postgres=# insert into t select i,  md5(i::text), md5(i::text), md5(i::text) from generate_series(1,1000000) i;
>..
>>  client backend |       207 | normal
>>  client backend |         0 | vacuum
>>
>> Shouldn't these evictions show up under context blkwrite? The description in docs is:

>No, that's not the case because INSERT doesn't execute a bulk
>write. It is is only performed during COPY FROM, and the write side of
>some other comands, such as CREATE AS (and some internal table-copy
>operations.).

Thanks, makes sense.

>> As far as I understand this, a ring buffer is used in this case. Do I miss something?

>Maybe you're confusiong it with bulk-read cases?

Yes, you're right.

Thank you
Daniel

pgsql-general by date:

Previous
From: Priess Stefan
Date:
Subject: AW: AW: Compile static postgres.lib for postgres 15.3 on Windows
Next
From: Priess Stefan
Date:
Subject: AW: AW: Compile static postgres.lib for postgres 15.3 on Windows