Re: Speaking of pgstats

Tom Lane wrote:
> "Magnus Hagander" <mha@sollentuna.net> writes:
> > While we're talking about pgstats...  There was some talk a while back
> > about the whole bufferer/collector combination perhaps being unnecessary
> > as well, and that it might be a good idea to simplify it down to just a
> > collector. I'm not 100% sure what the end result of that discussion was,
> > thouhg, and I can't find it in the archives :-(
> 
> Yeah, I was thinking that same thing this morning.  AFAIR we designed
> the current structure "on paper" in a pghackers thread, and never did
> any serious experimentation to prove that it was worth having the extra
> process.  I concur it's worth at least testing the simpler method.

My research is in the hold queue:
http://momjian.postgresql.org/cgi-bin/pgpatches_hold

Subject is "Stats collector performance improvement".  I am waiting for
someone to confirm my tests on other platforms before moving forward,
but we really should do something for 8.2.  If someone else wants to
work on it, go ahead.  All my work is in those emails.

--  Bruce Momjian   http://candle.pha.pa.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +