Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1d1DPT-0007kQ-So for pgsql-admin@arkaria.postgresql.org; Thu, 20 Apr 2017 14:50:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1d1DPS-0000r7-Ga for pgsql-admin@arkaria.postgresql.org; Thu, 20 Apr 2017 14:50:14 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d1DNe-0004R0-QD for pgsql-admin@postgresql.org; Thu, 20 Apr 2017 14:48:22 +0000 Received: from mail-qt0-x22c.google.com ([2607:f8b0:400d:c0d::22c]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1d1DNc-00088E-Ae for pgsql-admin@postgresql.org; Thu, 20 Apr 2017 14:48:21 +0000 Received: by mail-qt0-x22c.google.com with SMTP id m36so46935131qtb.0 for ; Thu, 20 Apr 2017 07:48:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:subject:date:message-id:mime-version:thread-index :content-language; bh=uLSfIlmwo9rpQYRQkZKabdHW0HaMxnwla2EHW85Whb4=; b=OOjcuDupyl0RJ8EcNm5iecd+7LPiBgpJGQbs+YOX4mPBnvAJdeLOgkoiFFXe9aZFqW ocm0fXtggWcpw1jRRcSjqWSdHWZNQvfb359C+3O2MjA+nq2g1ExM7o7kGKVc+4DfW8qr oOZH+xoGCJlai5fR476hibYvcYSqSFPO6kjN/jhm6UD9LKZkiU4+8htT+yAx2aMDbd6J dC8XHuK61Vu+Uc7BE1mtMLGoVvUe+oX7EpvimzgjWWA1jM6HKIItO5R8xN3yZHEcjbSU 2nuKAA7Y4EpXtMX5Ye96bUabPn1FaTO7ToJNZYWLPzWce0c7DO/pd8weni4MVo3N+Ry+ DcTw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:date:message-id:mime-version :thread-index:content-language; bh=uLSfIlmwo9rpQYRQkZKabdHW0HaMxnwla2EHW85Whb4=; b=Mzk3ihP7LD71FJ0vFNA7qUDa9Qd42J9u71LMNe+FAKsr6kS1smYgwUVp4kSmJ/y2OD tfANb1pOa6qDiSyp7M4cndz+mNwE8JOQgYIHY/YdUF7cmWWe6U3h8Pn73ZrvfyaJbYfJ vUx86ljgzMvycTeLwTOtbfVdN4ggf9SniRkhTtoUccGjf0nkFlMbBmQnugINV8DlFKvy 2Q5Jmi0937ZM9ZkUobQtNXauDP5rWR3IPB5VGnkpAWTAWyPdAC8a5VkR+/r8ec6PXuBO blSzW2SOfUhIfipabBMR7AhyfkHe4kxwMGJZ9Z0hSQn/dZ+RhC5kE0Iquu/FLpuAakBu K9KA== X-Gm-Message-State: AN3rC/6llwCacnXWVPlmp1H+pd8VuyRGIZxpG4x5cpr7uRG3bfS0/Bmi ucgFCFucXEWZnu7O X-Received: by 10.200.54.125 with SMTP id n58mr8891093qtb.145.1492699699347; Thu, 20 Apr 2017 07:48:19 -0700 (PDT) Received: from irylachi ([200.55.161.75]) by smtp.gmail.com with ESMTPSA id k40sm4298125qtf.27.2017.04.20.07.48.17 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Thu, 20 Apr 2017 07:48:18 -0700 (PDT) From: "Lazaro Garcia" To: Subject: Which way would be more efficient to configure in PgBouncer, session mode or transaction mode? Date: Thu, 20 Apr 2017 10:48:14 -0400 Message-ID: <000d01d2b9e5$250a0a30$6f1e1e90$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000E_01D2B9C3.9DF86A30" X-Mailer: Microsoft Outlook 15.0 Thread-Index: AdK55QzxsWed81xbQ22/+UP5DYjc5w== Content-Language: es-mx X-Pg-Spam-Score: -1.7 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_000E_01D2B9C3.9DF86A30 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello everyone. Could anyone give me their recommendations related to more efficient pool mode to use in PgBouncer, session mode or transaction mode, in order to obtain a better performance of PostgreSQL? Can anyone share me some links where I could read about this? Regards ------=_NextPart_000_000E_01D2B9C3.9DF86A30 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello everyone. Could anyone give = me their recommendations related to more efficient pool mode to use in = PgBouncer, session mode or transaction mode, in order to obtain a better = performance of PostgreSQL?

 

Can anyone share me some links = where I could read about this?

 

Regards

------=_NextPart_000_000E_01D2B9C3.9DF86A30--