| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com> |
| Cc: | Postgres General Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Warning when selecting column from pg_stat_user_tables. |
| Date: | 2010-02-09 14:10:13 |
| Message-ID: | 4B716CC5.7000305@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2010-02-09 14:11:54 | Re: string reverse fucntion? |
| Previous Message | Chris Barnes | 2010-02-09 13:52:06 | Warning when selecting column from pg_stat_user_tables. |