Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1frrAW-0007Su-Gr for pgsql-performance@arkaria.postgresql.org; Mon, 20 Aug 2018 20:52:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1frrAU-0007uX-RC for pgsql-performance@arkaria.postgresql.org; Mon, 20 Aug 2018 20:52:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1frrAU-0007uL-Gr for pgsql-performance@lists.postgresql.org; Mon, 20 Aug 2018 20:52:54 +0000 Received: from mail-it0-x236.google.com ([2607:f8b0:4001:c0b::236]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1frrAR-0006Th-8u for pgsql-performance@lists.postgresql.org; Mon, 20 Aug 2018 20:52:54 +0000 Received: by mail-it0-x236.google.com with SMTP id h20-v6so1294667itf.2 for ; Mon, 20 Aug 2018 13:52:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=76Z2mw+LS00xT3jDP87Cqk1oIM4LdDF6O0cs/o3EsE0=; b=cjwJhGBPqh+mr/uq5KfFTWhMMqHSM1F/gtSSE5rx+ltKdN7FJFQrZUP1yqYpYkxzn9 euP+VorCbmL+fPAZmF9AGrnO21gMg8tyqQHTkCx3oR7InP0bBPid8sl0KYGCB/XPs+9S puELHf0mp/5KD4gE3qQM2uB0jEjvyrHyTcFvbb2lMYB29k57+NZ2R0y47THb106F54KC X830lVhyCJAc+FI0xIa9Y4rAeG28i8TxWX/n7xe18+gVf1xvkt/JUOxVpCxN8l/IMLtg CyhlIeTDoJCyEi8wtACBb7vvcLyTr+SvarcFvkY3P7UxiFQaVUsUZ7klEQGBAlwn9FT+ x8ag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=76Z2mw+LS00xT3jDP87Cqk1oIM4LdDF6O0cs/o3EsE0=; b=oCpuK0AK7vicOTu4FpdWvyqIzfSw1l5lvT/iD8GnIwh3lQVabrvn6p+/ifHFAo3H+q 0YmDv5buRoZLw1YGPiLVL5+kfWDDVHGm8yynPf8/2Co1YrX/Y9I7j8ufQRin8OE6nJ1n AYiVkyuc1ZUChRwGmObhiQMcBsO37/8LU8pQIoSDLA94cf6ouvftXelKsFUnpldSxXYg uOPi9cC4q4EMZ7f0j/RefBSgxcc2ZCcX/SgtvAuqAWHvWsLKOXJaLPXiLk0R6JSRZyNo HIdblCEIaOH/Dzz4JUT1WKbGGwJykCmX2rnF53cM+IhoZWoyBXsLM7BCr00QRtGqGuSC jQfw== X-Gm-Message-State: AOUpUlGn8CpEUuLMSnqxqO6GgHSMyea8ds4gTfQWdypLBCm2KAEQhqcb FMP4NccHBoYgfbBJMOHoknNhDZxE X-Google-Smtp-Source: AA+uWPy51QYygak4zwGPdPXrv63iNHY4OZqwQLlgkQTWAdHBB9k8FJXjNjxM8dLeQGx6Vk9S8HQKPw== X-Received: by 2002:a02:5103:: with SMTP id s3-v6mr41439832jaa.102.1534798368750; Mon, 20 Aug 2018 13:52:48 -0700 (PDT) Received: from [172.25.136.24] ([165.215.94.3]) by smtp.gmail.com with ESMTPSA id q68-v6sm295499itb.23.2018.08.20.13.52.47 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 20 Aug 2018 13:52:47 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-6E94C62B-7DBA-48DD-B789-B60A8AD5F395 Mime-Version: 1.0 (1.0) Subject: Re: Guideline To Resolve LWLock:SubtransControlLock From: Fred Habash X-Mailer: iPhone Mail (15G77) In-Reply-To: <20180817182645.nmfaw6w7qzqb2dau@alvherre.pgsql> Date: Mon, 20 Aug 2018 16:52:47 -0400 Cc: pgsql-performance@lists.postgresql.org Content-Transfer-Encoding: 7bit Message-Id: <82F3FC39-72DA-4C25-804A-212DE0E5ECB3@gmail.com> References: <20180817182645.nmfaw6w7qzqb2dau@alvherre.pgsql> To: Alvaro Herrera List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail-6E94C62B-7DBA-48DD-B789-B60A8AD5F395 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Thanks. =20 How do we go about calculating appropriate values for these two parameters .= .. > 'NUM_SUBTRANS_BUFFERS'? TOTAL_MAX_CACHED_SUBXIDS And do both require a recompile? =E2=80=94=E2=80=94=E2=80=94=E2=80=94- Thank you.=20 On Aug 17, 2018, at 2:26 PM, Alvaro Herrera wrote= : >> And as for the recompile, are you thinking 'NUM_SUBTRANS_BUFFERS'? >=20 > Yes, that's one option, but there's also TOTAL_MAX_CACHED_SUBXIDS. --Apple-Mail-6E94C62B-7DBA-48DD-B789-B60A8AD5F395 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Thanks.  
How do we go a= bout calculating appropriate values for these two parameters ...
<= br>
'NUM_SUBTRANS_BUFFERS'?
TOTAL_MAX_CACHED_SUBXIDS

And do both require a recompile?


=E2=80=94=E2=80=94=E2=80=94=E2=80=94-
= Thank you. 

On Aug 17, 2018, at 2:26 PM, Alvaro Her= rera <alvherre@2ndquadrant.co= m> wrote:

And as for the recompile, are you thin= king 'NUM_SUBTRANS_BUFFERS'?

Y= es, that's one option, but there's also TOTAL_MAX_CACHED_SUBXIDS.
= --Apple-Mail-6E94C62B-7DBA-48DD-B789-B60A8AD5F395--