Re: [HACKERS] Final Thoughts for 8.3 on LWLocking and Scalability

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] Final Thoughts for 8.3 on LWLocking and Scalability
Date: 2007-09-11 13:33:27
Message-ID: 1189517607.4281.474.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Tue, 2007-09-11 at 10:42 +0100, Simon Riggs wrote:

> 2. CountActiveBackends() searches the whole of the proc array, even
> though it could stop when it gets to commit_siblings. Stopping once the
> heuristic has been determined seems like the best thing to do. A small
> patch to implement this is attached.

backend/access/transam/xact.c | 2 !!
backend/storage/ipc/procarray.c | 11 !!!!!!!!!!!
include/storage/procarray.h | 2 !!
3 files changed, 15 modifications(!)

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

Attachment Content-Type Size
CountActiveBackends.v1.patch text/x-patch 3.6 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-09-11 13:46:42 Re: What is happening on buildfarm member dugong
Previous Message Sergey E. Koposov 2007-09-11 11:43:07 Re: What is happening on buildfarm member dugong

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-09-11 13:58:14 Re: CSStorm occurred again by postgreSQL8.2
Previous Message Pavan Deolasee 2007-09-11 12:17:01 Re: HOT patch - version 15