| From: | "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com> |
|---|---|
| To: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Understanding pg_stat_io.evictions |
| Date: | 2023-07-31 07:57:23 |
| Message-ID: | GV0P278MB0419D67F8EA158F25D4D8E29D205A@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Priess Stefan | 2023-07-31 08:16:14 | AW: AW: Compile static postgres.lib for postgres 15.3 on Windows |
| Previous Message | Priess Stefan | 2023-07-31 07:52:04 | AW: AW: Compile static postgres.lib for postgres 15.3 on Windows |