Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qprLQ-007KIP-Pi
	for pgsql-admin@arkaria.postgresql.org; Mon, 09 Oct 2023 14:34:52 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qprLO-00EkyW-BZ
	for pgsql-admin@arkaria.postgresql.org; Mon, 09 Oct 2023 14:34:51 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <mbanck@gmail.com>)
	id 1qprLN-00EkxS-W4
	for pgsql-admin@lists.postgresql.org; Mon, 09 Oct 2023 14:34:50 +0000
Received: from mail-ej1-x62d.google.com ([2a00:1450:4864:20::62d])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <mbanck@gmail.com>)
	id 1qprLL-000ncC-V0
	for pgsql-admin@lists.postgresql.org; Mon, 09 Oct 2023 14:34:49 +0000
Received: by mail-ej1-x62d.google.com with SMTP id
 a640c23a62f3a-9b95622c620so846982166b.0
        for <pgsql-admin@lists.postgresql.org>;
 Mon, 09 Oct 2023 07:34:47 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1696862086; x=1697466886;
 darn=lists.postgresql.org;
        h=user-agent:in-reply-to:content-disposition:mime-version:references
         :subject:cc:to:from:date:sender:message-id:from:to:cc:subject:date
         :message-id:reply-to;
        bh=n8GnmCnUS5kMLoA9nhplIoPaErO1h7pnDECLhHYaGjU=;
        b=WTmWjQxr2T6gD80zcN8OxcecUPkErlcwKgZOmDXbpX/Y3j1tBJjOQfnH9xSDP1Y7r7
         UlMh2kOgL5AiuDAB0KFFBFVrw7QeOUxkewK2s7IsaVG7qz8yNmxklE5dBm58Dh3w7VPQ
         2xaVqwGnDZrD7ygvn4FJ7WpZaeyLs7Z3row18O4ezk6WbOHxXtMvR4aVrK8QjrXF3NN/
         5LnERIbHIBK0eG1ONVQsTb5YwBLWexZJvfW/Z+h5a7+CRuvfJQ8hcD1YEt9oHfw2MJIK
         AmaX5xmacz91djIInxSZVlyvHdcQJ9iXAI4i0QlJkUfNwQZxIV0w9TJ43vK1lpAAo1ky
         IxVA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1696862086; x=1697466886;
        h=user-agent:in-reply-to:content-disposition:mime-version:references
         :subject:cc:to:from:date:sender:message-id:x-gm-message-state:from
         :to:cc:subject:date:message-id:reply-to;
        bh=n8GnmCnUS5kMLoA9nhplIoPaErO1h7pnDECLhHYaGjU=;
        b=CZpstiJ80ETCD6TWBwvxybPCSR9WnTzdRfzmq9p6EZATNxesAtVBJlRDC/jlBkEYD9
         8iAXAr06yFbrV8qHpO0EPFQMvitcyoxBw9LrnGM9XRylrtCOZODi/LspXdcOz6SMlSN7
         0GfCilyunVn3IHBxuQPlh9Mz1ww/exd4JB2SzVftvCNVJ2kX0wjhuP9TtbEQtFCA/1Xv
         1EeQTHdAr8ZJBx7VfIloxzMh+dZBApUc2NyT9enIXLICCcC1JNR6CkNx+Fe9XLkU9x0M
         IbR37liLzJRBPnMJncZniXldpd0L4Zi/XXOeLP7BhQgc9AVOxfJgKqfVq8ZPQWEi48pD
         RuMQ==
X-Gm-Message-State: AOJu0YxTOfWsfp5fCDqB95TxflkVU//axNvArzElf1cdIeAVOJTGlu2z
	0+jvqntXeW1P30hHiUsRbs4=
X-Google-Smtp-Source: 
 AGHT+IGEdK7hijG9mttqcprHRGlMm4bYxPtra9R0tDVYl/9elJNCGLmJhVr2pblEOKGSxrdfcR0A2g==
X-Received: by 2002:a17:907:75ce:b0:9ae:65e5:497d with SMTP id
 jl14-20020a17090775ce00b009ae65e5497dmr12748057ejc.59.1696862086171;
        Mon, 09 Oct 2023 07:34:46 -0700 (PDT)
Received: from lightning.caipicrew.dd-dns.de
 ([2001:a61:34cf:1001:f11c:3b32:31b7:711])
        by smtp.gmail.com with ESMTPSA id
 ce24-20020a170906b25800b0098669cc16b2sm6777278ejb.83.2023.10.09.07.34.45
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Mon, 09 Oct 2023 07:34:45 -0700 (PDT)
Message-ID: <65240f85.170a0220.bf62b.47d6@mx.google.com>
X-Google-Original-Message-ID: 
 <20231009143444.GL27104@caipicrew.dd-dns.de;lightning.caipicrew.dd-dns.de>
Sender: Michael Banck <mbanck@gmail.com>
Received: from mbanck by lightning.caipicrew.dd-dns.de with local (Exim 4.92)
	(envelope-from <mbanck@caipicrew.dd-dns.de>)
	id 1qprLJ-0000UA-0Z; Mon, 09 Oct 2023 16:34:45 +0200
Date: Mon, 9 Oct 2023 16:34:45 +0200
From: Michael Banck <mbanck@gmx.net>
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Cc: Ron <ronljohnsonjr@gmail.com>,
	Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Discard All in pgbouncer
References: 
 <CAJk5AtachHvTqeMT=Y+3wKaRgQnO8ypBUPvGQK4JFH5thkxcew@mail.gmail.com>
 <d7af179d-714f-ebe2-ddb7-19a1dffdd7b4@gmail.com>
 <CAJk5AtYQTC2bc3Sba=r+LqjNa=XZuV7HnSqoNPbtoOm7t3TWkA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAJk5AtYQTC2bc3Sba=r+LqjNa=XZuV7HnSqoNPbtoOm7t3TWkA@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/65240f85.170a0220.bf62b.47d6%40mx.google.com>
Precedence: bulk

Hi,

On Mon, Oct 09, 2023 at 07:52:55PM +0530, Rajesh Kumar wrote:
> Purpose of bouncer is handle idle connections right? Is there a time period
> for the DISCARD ALL to go away? If so, how to configure?
> 
> The part I don't understand is if bunch of connections in the name of
> Discard all is idle ,  what difference it make?
> 
> If I have set Max conn in db as 250....do I have to set the same in
> pgbouncer?

You wrote the exact same text in another reply. Please don't
double-post.


Michael