| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Magnus Hagander <magnus(at)hagander(dot)net> |
| Cc: | PGSQL-Patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: bgwriter stats |
| Date: | 2007-03-19 22:32:12 |
| Message-ID: | 18157.1174343532@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Magnus Hagander <magnus(at)hagander(dot)net> writes:
> I want to be able to pull some stats out of the bgwriter to be able to
> track things. One thing is the total number of buffers written out.
> Other things are the "number of checkpoints" and such.
> Anyway. Attached patch adds this to the bgwriter shared memory. Is it
> safe to do this, and then just have a regular function running in a
> normal backend pulling out the value and returning it to the user,
> without locking? Given that only the bgwriter can write to it?
This seems quite a bizarre way to do things. Why wouldn't you implement
this functionality by shipping messages to the stats collector?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-03-19 22:39:28 | Re: bgwriter stats |
| Previous Message | Magnus Hagander | 2007-03-19 20:36:15 | Re: bgwriter stats |