Re: WARNING: pgstat waiting

On 10 September 2011 17:40, Andy Colson <andy(at)squeakycode(dot)net> wrote:
> I'm playing with 9.2devel, and I can fill my logs with:
>
> WARNING:  pgstat waiting for 5001623 usec (494 loops), file timestamp
> 368986878169601 target timestamp 368986897680812 last errno 0
> WARNING:  pgstat waiting for 5011780 usec (495 loops), file timestamp
> 368986878169601 target timestamp 368986897680812 last errno 0
> WARNING:  pgstat waiting for 5021947 usec (496 loops), file timestamp
> 368986878169601 target timestamp 368986897680812 last errno 0
> WARNING:  pgstat waiting for 5032115 usec (497 loops), file timestamp
> 368986878169601 target timestamp 368986897680812 last errno 0
> WARNING:  pgstat waiting for 5042254 usec (498 loops), file timestamp
> 368986878169601 target timestamp 368986897680812 last errno 0
> WARNING:  pgstat waiting for 5052400 usec (499 loops), file timestamp
> 368986878169601 target timestamp 368986897680812 last errno 0
>
> I see its from here:
>
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=79b2ee20c8a041a85dd230c4e787bef22edae57b
>
> So I was wondering if there is anything I can help with?  Not sure if you
> need a reproducible case, or something you'd like me to try?

I've had exactly the same sort of messages, pages of them. But wasn't
quite sure what I needed to recreate it.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company