Postgres Pro
Downloads
Home   >   mailing lists

WARNING : pgstat wait timeout - Postgres 9.1 - Mailing list pgsql-hackers

From Mathieu Guerin
Subject WARNING : pgstat wait timeout - Postgres 9.1
Date
Msg-id CAFssqjNsFrVqTr60uScnyS3QpUb0NhXzLYS+YYMdRGKzE4ko5w@mail.gmail.com
Whole thread Raw
Responses Re: WARNING : pgstat wait timeout - Postgres 9.1  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Tree view
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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Heap truncation without AccessExclusiveLock (9.4)
Next
From: Robert Haas
Date:
Subject: Re: MVCC catalog access