Skip site navigation (1) Skip section navigation (2)

reserved_superuser_connections tweak

From: Neil Conway <neilc(at)samurai(dot)com>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: reserved_superuser_connections tweak
Date: 2002-11-20 18:28:45
Message-ID: 87el9g5c4i.fsf@mailbox.samurai.com (view raw or flat)
Thread:
Lists: pgsql-patches
There's no point counting the # of empty backend slots (which requires
grabbing an LWLock) unless

        (a) the # of reserved slots is > 0

        (b) the current user is not a superuser

Thus, we can sometimes get away without grabbing the lock

Cheers,

Neil

-- 
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC

Attachment: reserved_conn_fix-1.patch
Description: text/x-patch (1.7 KB)

Responses

pgsql-patches by date

Next:From: Neil ConwayDate: 2002-11-20 22:18:41
Subject: Re: documentation for reserved_superuser_connections
Previous:From: Neil ConwayDate: 2002-11-20 18:20:21
Subject: documentation for reserved_superuser_connections

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group