Re: Optimizing Read-Only Scalability - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Optimizing Read-Only Scalability
Date
Msg-id 4A0CA796.4030601@agliodbs.com
Whole thread Raw
In response to Optimizing Read-Only Scalability  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Optimizing Read-Only Scalability  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Simon,

> 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?

-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Translation updates
Next
From: Fujii Masao
Date:
Subject: Re: New trigger option of pg_standby