pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Craig Ringer <ringerc@ringerc.id.au>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: CSS <css@morefoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: select operations that generate disk writes
Date: Fri, 06 Jul 2012 14:52:27 +0800
Message-ID: <4FF68B2B.50505@ringerc.id.au> (raw)
In-Reply-To: <CAFj8pRDijqBPdGen1BggTfnNzpfNHLo=t6n1gRZoiiB6o4J7kQ@mail.gmail.com>
References: <C6B622D6-5DE1-48FB-BF8B-2C8065FEA346@morefoo.com>
	<CAFj8pRDijqBPdGen1BggTfnNzpfNHLo=t6n1gRZoiiB6o4J7kQ@mail.gmail.com>

On 07/06/2012 02:20 PM, Pavel Stehule wrote:
> Hello
>
> 2012/7/6 CSS <css@morefoo.com>:
>> So my question is, what else can generate writes when doing read-only operations?  I know it sounds like a simple question, but I'm just not finding a concise answer anywhere.
> statistics http://www.postgresql.org/docs/9.1/interactive/runtime-config-statistics.html
>

  Hint bits, too:

http://wiki.postgresql.org/wiki/Hint_Bits

--
Craig Ringer

view thread (3+ messages)

Message-ID: <4FF68B2B.50505@ringerc.id.au>
Permalink:  ../4FF68B2B.50505@ringerc.id.au/
Also on:    postgresql.org/message-id/4FF68B2B.50505@ringerc.id.au

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ringerc@ringerc.id.au, pavel.stehule@gmail.com, css@morefoo.com
  Subject: Re: select operations that generate disk writes
  In-Reply-To: <4FF68B2B.50505@ringerc.id.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox