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
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
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 "