Search Postgresql Archives

Re: EXPLAIN BUFFERS: dirtied

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: EXPLAIN BUFFERS: dirtied
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Mon, 29 Jan 2018 13:38:35 -0500
Cc: pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to Vitaliy Garnashevich <vgarnashevich@xxxxxxxxx> message dated "Mon, 29 Jan 2018 20:31:53 +0200"
In-reply-to: <21a14f5f-b39c-3aa8-da2c-2112ee328b93@gmail.com>
References: <21a14f5f-b39c-3aa8-da2c-2112ee328b93@gmail.com>

Vitaliy Garnashevich <vgarnashevich@xxxxxxxxx> writes:
> But what is "dirtied" statistics? When a SELECT query could make pages 
> dirty?

Setting hint bits on recently-committed rows.

			regards, tom lane

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: EXPLAIN BUFFERS: dirtied
  - From: Vitaliy Garnashevich

References:
- EXPLAIN BUFFERS: dirtied
  - From: Vitaliy Garnashevich

Prev by Date: EXPLAIN BUFFERS: dirtied
Next by Date: Re: pg 10.1 missing libpq in postgresql-devel
Previous by thread: EXPLAIN BUFFERS: dirtied
Next by thread: Re: EXPLAIN BUFFERS: dirtied
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux