Search Postgresql Archives

Re: Warning when selecting column from pg_stat_user_tables.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 09/02/10 13:52, Chris Barnes wrote:

I have this error when selecting from the pg_stat_user_tables. I
restarted postgres and the error went away.

Has anyone else seen this error?

Chris Barnes


[postgres@preventdb02 londiste]$ cat
/data/pgsql/data/pg_log/postgresql-Tue.log

WARNING:  pgstat wait timeout
> WARNING:  pgstat wait timeout

No, but I can tell you (roughly) what it is. The stats collector is a separate process, and it's designed to drop messages if it gets busy. Normally, that would be details of updates being discarded, but in this case it's presumably your read request that gets thrown away.

If it occurs again, check "top" and see if the stats collector looks busy.

--
  Richard Huxton
  Archonet Ltd

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux