Magnus Hagander <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq