Re: EXPLAIN BUFFERS: dirtied

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vitaliy Garnashevich <vgarnashevich(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: EXPLAIN BUFFERS: dirtied
Date: 2018-01-29 18:38:35
Message-ID: 6040.1517251115@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vitaliy Garnashevich <vgarnashevich(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message support-tiger 2018-01-29 19:18:59 Re: pg 10.1 missing libpq in postgresql-devel
Previous Message Vitaliy Garnashevich 2018-01-29 18:31:53 EXPLAIN BUFFERS: dirtied