From: | Artem Tomyuk <admin(at)leboutique(dot)com> |
---|---|
To: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Log says temporary files are being created |
Date: | 2016-06-22 15:57:31 |
Message-ID: | CANYYVqJaWVxoi6UQ5NOWd3gEwH+Mp4g4P523uJNzWYOSxDXVAQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Campbell, Lance | 2016-06-22 16:03:02 | Re: Log says temporary files are being created |
Previous Message | Campbell, Lance | 2016-06-22 15:50:49 | Log says temporary files are being created |