Postgres Pro
Downloads
Home   >   mailing lists

Re: Log says temporary files are being created - Mailing list pgsql-admin

From Artem Tomyuk
Subject Re: Log says temporary files are being created
Date
Msg-id CANYYVqJaWVxoi6UQ5NOWd3gEwH+Mp4g4P523uJNzWYOSxDXVAQ@mail.gmail.com
Whole thread Raw
In response to Log says temporary files are being created  ("Campbell, Lance" <lance@illinois.edu>)
Responses Re: Log says temporary files are being created
List pgsql-admin
Tree view
By default temp files are created on hard drive as a result of low work_mem setting in postgres.conf. If your server runs on slow desktop hdd's it could be serious bottleneck in your performance so Yes, you should be concerned about it and tune work_mem parameter. 

2016-06-22 18:50 GMT+03:00 Campbell, Lance <lance@illinois.edu>:

PostgreSQL 5.3.2

I am seeing entries like this appearing in my PostgreSQL log. 

 

Log entry:

temporary file: path "base/pgsql_tmp/pgsql_tmp10336.0", size 17809408

 

1)      Should this concern me?

2)      What would I need to modify in my configuration in order to stop temporary file creation from occurring?

 

Thanks,

 

Lance


pgsql-admin by date:

Previous
From: "Campbell, Lance"
Date:
Subject: Log says temporary files are being created
Next
From: "Campbell, Lance"
Date:
Subject: Re: Log says temporary files are being created