[PERFORM] select operations that generate disk writes

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

Re: [PERFORM] select operations that generate disk writes

Hello 2012/7/6 CSS c...@morefoo.com: 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?).

Re: [PERFORM] select operations that generate disk writes

On 07/06/2012 02:20 PM, Pavel Stehule wrote: Hello 2012/7/6 CSS c...@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