Re: [HACKERS] WARNING : pgstat wait timeout - Postgres 9.1

2013-05-24 Thread Mathieu Guerin
Hello, Thanks a lot for your answers. You should get it... stats_temp_directory | pg_stat_tmp | Writes temporary statistics files to the specified directory. I don't know why i don't get it. I am in 9.1 version... Moreover, when I mount pg_stat_tmp

Re: [HACKERS] WARNING : pgstat wait timeout - Postgres 9.1

2013-05-24 Thread Mathieu Guerin
About the stats_temp_directory, I didn't run as root... Now I'm sure the configurations are correct. I think, I have too much IO to use stats. I will ever have this message... Maybe I can disable this option. Do you know what it really impact ? Thanks. Math 2013/5/24 Mathieu Guerin

[HACKERS] WARNING : pgstat wait timeout - Postgres 9.1

2013-05-23 Thread Mathieu Guerin
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

Re: [HACKERS] WARNING : pgstat wait timeout - Postgres 9.1

2013-05-23 Thread Michael Paquier
On Thu, May 23, 2013 at 9:31 PM, Mathieu Guerin mathieu.gueri...@gmail.comwrote: 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