WARNING : pgstat wait timeout - stats_temp_directory - postgres 9.1

Поиск
Список
Период
Сортировка
От Mathieu Guerin
Тема WARNING : pgstat wait timeout - stats_temp_directory - postgres 9.1
Дата
Msg-id CAFssqjM7Fbop2QdQ-kyNn50C5oGKvV1Z0ayUisDGQdh5G9q3Cw@mail.gmail.com
обсуждение исходный текст
Ответы Re: WARNING : pgstat wait timeout - stats_temp_directory - postgres 9.1
Список pgsql-hackers
Дерево обсуждения
Hello,

I am facing a problem with pgstat as my subject says. I known, some topics are open about that, but I would like to go deeper.

Some person told that the better way to don't have this message anymore is to configure pgstat.stat to be loaded in the RAM with a tmpfs mount point.

What are the consequences ? Because this file will be remove if the server reboot.

If we change the parameter stats_temp_directory is it necessary to reboot the server ?

When I lauch a SHOW ALL; command, the parameter stats_temp_director is not here.

For information, my pgstat.stat file is up to 1,3MB.

Thank you for your help.
Math



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Atri Sharma
Дата:
Сообщение: Time limit for a process to hold Content lock in Buffer Cache
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Time limit for a process to hold Content lock in Buffer Cache