Re: select operations that generate disk writes

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: CSS <css(at)morefoo(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: select operations that generate disk writes
Date: 2012-07-06 06:52:27
Message-ID: 4FF68B2B.50505@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 07/06/2012 02:20 PM, Pavel Stehule wrote:
> Hello
>
> 2012/7/6 CSS <css(at)morefoo(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Daniel Farina 2012-07-06 09:46:18 Re: how could select id=xx so slow?
Previous Message Pavel Stehule 2012-07-06 06:20:29 Re: select operations that generate disk writes