Re: WARNING : pgstat wait timeout - Postgres 9.1
| От | Michael Paquier |
|---|---|
| Тема | Re: WARNING : pgstat wait timeout - Postgres 9.1 |
| Дата | |
| Msg-id | CAB7nPqShYvx1XovxVJOdU+kq8UoymQ6QKwMRFZShjd6ucjOb7Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | WARNING : pgstat wait timeout - Postgres 9.1 (Mathieu Guerin <mathieu.guerin64@gmail.com>) |
| Ответы |
Re: WARNING : pgstat wait timeout - Postgres 9.1
|
| Список | pgsql-hackers |
On Thu, May 23, 2013 at 9:31 PM, Mathieu Guerin <mathieu.guerin64@gmail.com> wrote:
-- What are the consequences ? Because this file will be remove if the server reboot.
Those temporary statistics are stored in global directory when server shuts down, so the risk here would be to lose a portion of this data in the case of a crash, either at PG or at OS level.
If we change the parameter stats_temp_directory is it necessary to reboot the server ?
No, sending SIGHUP to the server is enough.
When I lauch a SHOW ALL; command, the parameter stats_temp_director is not here.
You should get it...
stats_temp_directory | pg_stat_tmp | Writes temporary statistics files to the specified directory.
stats_temp_directory | pg_stat_tmp | Writes temporary statistics files to the specified directory.
Michael
В списке pgsql-hackers по дате отправления: