Thanks a lot. I really appreciate your assistance. I will make the change tomorrow morning.
Lance
From: Artem Tomyuk [mailto:admin@leboutique.com] Sent: Wednesday, June 22, 2016 11:09 AM To: Campbell, Lance <lance@illinois.edu> Cc: pgsql-admin@postgresql.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.
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.