| From: | Nicolas Zin <nicolas(dot)zin(at)savoirfairelinux(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | select * from pg_stat_bgwriter slow |
| Date: | 2013-05-14 20:57:06 |
| Message-ID: | 5192A522.3040002@savoirfairelinux.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
we have a postgresql 9.0, I setup collectd to gather some information.
It frequently ask the database about the bgwriter state by requesting
"select * from pg_stat_bgwriter" (among other stats).
It seems that this requets takes 6-7s to answer and in the log we got
"pgstat timeout"
Note: The database is constantly loaded with insert (but not overloaded).
Does someone have an idea why such request can take so long to answer. I
was thinking bgwriter stats is just a matter of picking global info in
memory. Can it be due to locks of some sort ?
Cordialy,
Nicolas Zin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Strahinja Kustudić | 2013-05-14 21:13:42 | Re: Steps to switch from Master to standby mode : |
| Previous Message | prakhar jauhari | 2013-05-14 04:47:07 | Re: Point in time recovery + replication |