Re: [PERFORM] select operations that generate disk writes

2012-07-05 Thread Craig Ringer
On 07/06/2012 02:20 PM, Pavel Stehule wrote: Hello 2012/7/6 CSS : 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/int

Re: [PERFORM] select operations that generate disk writes

2012-07-05 Thread Pavel Stehule
Hello 2012/7/6 CSS : > Hello, > > Time for a broad question. I'm aware of some specific select queries that > will generate disk writes - for example, a sort operation when there's not > enough work_mem can cause PG to write out some temp tables (not the correct > terminology?). That scenario

[PERFORM] select operations that generate disk writes

2012-07-05 Thread CSS
Hello, Time for a broad question. I'm aware of some specific select queries that will generate disk writes - for example, a sort operation when there's not enough work_mem can cause PG to write out some temp tables (not the correct terminology?). That scenario is easily remedied by enabling "