Re: Optimizing Read-Only Scalability

On Thu, 2009-05-14 at 16:21 -0700, Josh Berkus wrote:

> > So we can optimize away the scan through the procarray by doing two "if"
> > tests, one outside of the lock, one inside. In normal running, both will
> > be optimized away, though in read-only periods we would avoid much work.
> 
> How much work would it be to work up a test patch?

Not much. The most important thing is a place to test it and access to
detailed feedback. Let's see if Dimitri does this.

There are some other tuning aspects to be got right first also, but
those are already known.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support