Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm asking about this here because in the PostgreSQL mailing lists no one answered me. In one of my servers (Windows 2008 R2 Standard/PostgreSQL 9.0.5 64 bits) the logs are being flooded with the following message:

2012-03-26 00:00:11 BRT AVISO:  pgstat wait timeout
2012-03-26 00:00:19 BRT AVISO:  pgstat wait timeout
2012-03-26 00:00:31 BRT AVISO:  pgstat wait timeout

I checked other threads in the PostgreSQL mailing lists that were answered, but there are no definitive answer. Some speculate about I/O overload, but I don't think it would cause this message to be logged almost all the time that the server is up. Do you, that use the combination of Windows+Postgresql, have ever had this problem? If yes, were you able to fix or identify the problem?


share|improve this question
I've had the problem. Rebooting the db server solved it, at least for a while. I'm in the same boat as you, trying to find an answer! – Scott Herbert Feb 10 '13 at 22:23

Reloading the config makes the errors go away, and performance improves (and db statistics start getting recorded again).

I've set up a Windows Scheduled Task which performs a pg_ctl reload -D"insert here the address of your pg directory" on the hour (we're running an incredibly busy application). Hacky, but it's working.

share|improve this answer
Hi Scott. The cause of this problem remains a mystery. There's [patch] (…) that was to be included in version 9.2 of PostgreSQL. It can help identify the problem, but I didn't had the time to test. – Norba Feb 14 '13 at 15:29

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.