Обсуждение: Log says temporary files are being created

Поиск
Список
Период
Сортировка

Log says temporary files are being created

От
"Campbell, Lance"
Дата:

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

Re: Log says temporary files are being created

От
Artem Tomyuk
Дата:
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


Re: Log says temporary files are being created

От
"Campbell, Lance"
Дата:

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@leboutique.com]
Sent: Wednesday, June 22, 2016 10:58 AM
To: Campbell, Lance <lance@illinois.edu>
Cc: pgsql-admin@postgresql.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@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

 

Re: Log says temporary files are being created

От
Artem Tomyuk
Дата:
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@illinois.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@leboutique.com]
Sent: Wednesday, June 22, 2016 10:58 AM
To: Campbell, Lance <lance@illinois.edu>
Cc: pgsql-admin@postgresql.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@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

 


Re: Log says temporary files are being created

От
"Campbell, Lance"
Дата:

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. 

 

2016-06-22 19:03 GMT+03:00 Campbell, Lance <lance@illinois.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@leboutique.com]
Sent: Wednesday, June 22, 2016 10:58 AM
To: Campbell, Lance <lance@illinois.edu>
Cc: pgsql-admin@postgresql.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@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

 

 

Re: Log says temporary files are being created

От
Artem Tomyuk
Дата:
you are welcome.

PS
You should think about updating postgres distro to. 

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

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. 

 

2016-06-22 19:03 GMT+03:00 Campbell, Lance <lance@illinois.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@leboutique.com]
Sent: Wednesday, June 22, 2016 10:58 AM
To: Campbell, Lance <lance@illinois.edu>
Cc: pgsql-admin@postgresql.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@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