log_temp_files (integer), tuning work_mem

From: Tory M Blue <tmblue(at)gmail(dot)com>
To: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: log_temp_files (integer), tuning work_mem
Date: 2014-11-05 21:32:37
Message-ID: CAEaSS0Z7xq_gXnF0GtSG+cjjYKBbzpmX3XVHCSQGOQ2rUYAsAA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

log_temp_files (integer)
Controls logging of temporary file names and sizes. Temporary files can be
created for sorts, hashes, and temporary query results. A log entry is made
for each temporary file when it is deleted. A value of zero logs all
temporary file information

so I've set this to;

log_temp_files = 0 # log temporary files equal or
larger

Reloaded the config and still have not seen a creation or deletion of a log
file. Is this still valid in 9.3 and do I need to change anything else?

I've got duration queries spitting out;

2014-11-05 12:11:32 PST rvtempdb postgres [local] 31338 2014-11-05
12:11:32.257 PSTLOG: duration: 1609.707 ms statement: COPY adgroups
(adgroup_id, name, status, campaign_id, create_date, modify_date) FROM
stdin;

So logging is working.

I'm set to info ;

log_min_messages = info

So what would be the cause of not seeing anything ,and how can one turn
work_mem without seeing these entries?

Thanks!
Tory

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Artūras Lapinskas 2014-11-05 21:42:43 Index order ignored after `is null` in query
Previous Message Tory M Blue 2014-11-05 19:16:00 Re: 9.3 performance issues, lots of bind and parse log entries