|
>> 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
|
