Re: EXPLAIN BUFFERS: dirtied
От | Vitaliy Garnashevich |
---|---|
Тема | Re: EXPLAIN BUFFERS: dirtied |
Дата | |
Msg-id | cf69d9d5-18f1-288b-c70c-186b3cde64dd@gmail.com обсуждение исходный текст |
Ответ на | Re: EXPLAIN BUFFERS: dirtied (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: EXPLAIN BUFFERS: dirtied
|
Список | pgsql-general |
I've read this article: https://wiki.postgresql.org/wiki/Hint_Bits It says: > A plain SELECT, count(*), or VACUUM on the entire table will check > every tuple for visibility and set its hint bits. Suppose, a new page was created using many INSERTs, and then was written to disk during a checkpoint. There were no SELECTs or VACUUM on the page or table yet. Will the following SELECT of one tuple from the page update hint bits for ALL tuples on the page? Is that correct? When a page is initially created and then is being written to disk during a checkpoint, does checkpoint writer update the hint bits before writing the page, or the following SELECT/VACUUM will have to do that (possibly loading/updating/writing the page again)? Regards, Vitaliy On 2018-01-29 20:38, Tom Lane wrote: > Vitaliy Garnashevich <vgarnashevich@gmail.com> writes: >> But what is "dirtied" statistics? When a SELECT query could make pages >> dirty? > Setting hint bits on recently-committed rows. > > regards, tom lane >
В списке pgsql-general по дате отправления: