From: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> |
---|---|
To: | daniel(dot)westermann(at)dbi-services(dot)com |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Understanding pg_stat_io.evictions |
Date: | 2023-07-31 01:32:25 |
Message-ID: | 20230731.103225.1462984873937243644.horikyota.ntt@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
At Fri, 28 Jul 2023 10:36:46 +0000, "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com> wrote in
> 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.).
> 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?
regards.
--
Kyotaro Horiguchi
NTT Open Source Software Center
From | Date | Subject | |
---|---|---|---|
Next Message | Amn Ojee Uw | 2023-07-31 02:22:07 | Re: Upgrading |
Previous Message | Kaushal Shriyan | 2023-07-31 00:36:11 | Re: Migrating MySQL DB to PostgreSQL DB. |