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 in a tmpfs, the warning messages decrease the warning messages decrease from 1 each minutes to 1 each five secondes. I don't have any others logs warning but the file pg_stat.stat in the mounting point is not created... I tryed before on a test environment and it works... If you have any ideas... Thanks a lot. Regards, Math 2013/5/24 Michael Paquier <michael.paqu...@gmail.com> > > > > On Thu, May 23, 2013 at 9:31 PM, Mathieu Guerin < > mathieu.gueri...@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. > -- > Michael >