Thanks!
On 01/29/2018 08:21 PM, Vitaliy Garnashevich wrote:
> 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 create
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 checkpoi
Vitaliy Garnashevich writes:
> But what is "dirtied" statistics? When a SELECT query could make pages
> dirty?
Setting hint bits on recently-committed rows.
regards, tom lane
