| 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: | Whole Thread | Raw Message | 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
| 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 |