Re: Log says temporary files are being created

you are welcome.

PS
You should think about updating postgres distro to.

2016-06-22 19:42 GMT+03:00 Campbell, Lance <lance(at)illinois(dot)edu>:

> Thanks a lot. I really appreciate your assistance. I will make the
> change tomorrow morning.
>
>
>
> Lance
>
>
>
> *From:* Artem Tomyuk [mailto:admin(at)leboutique(dot)com]
> *Sent:* Wednesday, June 22, 2016 11:09 AM
>
> *To:* Campbell, Lance <lance(at)illinois(dot)edu>
> *Cc:* pgsql-admin(at)postgresql(dot)org
> *Subject:* Re: [ADMIN] Log says temporary files are being created
>
>
>
> it depends on how many RAM your server have? and how many concurrent
> connections served at one time.
>
> But from your log message its clear () that you should try to raise your
> work_mem setting from 16 to 20 megabytes.
>
>
>
> 2016-06-22 19:03 GMT+03:00 Campbell, Lance <lance(at)illinois(dot)edu>:
>
> This is occurring on a production system.
>
>
>
> My current work memory setting is:
>
>
>
> work_mem = 16MB
>
>
>
> Based on the temp file size that was created can I then deduce how much
> more to increase the work_mem by?
>
>
>
> Thanks for your assistance.
>
>
>
> Lance
>
>
>
>
>
> *From:* Artem Tomyuk [mailto:admin(at)leboutique(dot)com]
> *Sent:* Wednesday, June 22, 2016 10:58 AM
> *To:* Campbell, Lance <lance(at)illinois(dot)edu>
> *Cc:* pgsql-admin(at)postgresql(dot)org
> *Subject:* Re: [ADMIN] Log says temporary files are being created
>
>
>
> 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(at)illinois(dot)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
>
>
>
>
>