Re: [PERFORM] Techniques to Avoid Temp Files

2015-06-19 Thread Jeff Janes
On Thu, Jun 18, 2015 at 12:38 PM, Duane Murphy wrote: > We are trying to improve performance by avoiding the temp file creation. > > LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp8068.125071", size > 58988604 > STATEMENT: SELECT iiid.installed_item__id, item_detail.id, > item_detail.model_i

Re: [PERFORM] Techniques to Avoid Temp Files

2015-06-19 Thread Albe Laurenz
Duane Murphy wrote: > We are trying to improve performance by avoiding the temp file creation. > > LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp8068.125071", size > 58988604 > STATEMENT: SELECT iiid.installed_item__id, item_detail.id, > item_detail.model_id, item_detail.type > FROM instal

[PERFORM] Techniques to Avoid Temp Files

2015-06-18 Thread Duane Murphy
We are trying to improve performance by avoiding the temp file creation. LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp8068.125071", size 58988604 STATEMENT: SELECT iiid.installed_item__id, item_detail.id, item_detail.model_id, item_detail.type FROM installed_item__item_detail AS iiid INNER