Re: Optimizing Read-Only Scalability

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Optimizing Read-Only Scalability
Date: 2009-05-14 23:21:58
Message-ID: 4A0CA796.4030601@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2009-05-15 02:32:59 Re: New trigger option of pg_standby
Previous Message Tom Lane 2009-05-14 23:06:43 Re: [COMMITTERS] pgsql: Translation updates