pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Will Platnick <wplatnick@gmail.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: postgresql.conf recommendations
Date: Mon, 11 Feb 2013 18:29:32 -0500
Message-ID: <AC5A12F0DBD14B029E00AB870776DA71@gmail.com> (raw)
In-Reply-To: <CABMVzL1O1X5ixPiUzq0UXYegrXPEk4FOMWGMWBBW6DmDcX5oMA@mail.gmail.com>
References: <CABMVzL2y8mRM5C9xxejAyDqe0i1S78RAE3cEATGYNf5Ktz_Zdg@mail.gmail.com>
	<CAB6McgXMFS2XD_inm5LMSmZpYMoXm8mzF6t3JXVyJAqi_-98OA@mail.gmail.com>
	<CABMVzL3mmx8KOBCrVQzff3FciXg_DJGULd4f3an4a417FUb1XQ@mail.gmail.com>
	<CAB6McgUt0tBgZCYjRKgpPt41XPYLXwA8tcXDTp_vLTvwA1m30w@mail.gmail.com>
	<13A05E96-01A0-4B0A-8EA3-2A3B7FDF6838@hsk.hk>
	<1360154987.89420.YahooMailNeo@web162901.mail.bf1.yahoo.com>
	<CABMVzL0j=quCGWEdHO922kOjzmbqA7CntwMtE6abT=cx+sZaxQ@mail.gmail.com>
	<1360185170.99635.YahooMailNeo@web162903.mail.bf1.yahoo.com>
	<CADKbJJUhe9_tXZ-UCGycDGjA6v42Go3sSgvXSmRvBMYA9N8hNQ@mail.gmail.com>
	<BLU002-W93A8707C498E9A7EFC2241AB060@phx.gbl>
	<CABMVzL2eDrq7Zk7i-mDiw0c41N1W5-X2uZOce-yonDW79KTvtA@mail.gmail.com>
	<CAB6McgUE0Lv-KeOnmrhhds9+O1YQ69Gz-JD0JeCCQwD7fRfFUA@mail.gmail.com>
	<CABMVzL3x8_47Xs1ryMhh1UUT9LocXXCGCBPuVLqPEoz+ROGLQQ@mail.gmail.com>
	<CAB6McgWsKt5SjBPc-p8ifAySQy=9jKU8KFGCy20Cz0x+XPjKng@mail.gmail.com>
	<CABMVzL1O1X5ixPiUzq0UXYegrXPEk4FOMWGMWBBW6DmDcX5oMA@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

> We will probably tweak this knob some more -- i.e., what is the sweet spot between 1 and 100? Would it be higher than 50 but less than 100? Or is it somewhere lower than 50?
> 
> 

I would love to know the answer to this as well. We have a similar situation, pgbouncer with transaction log pooling with 140 connections.  What is the the right value to size pgbouncer connections to? Is there a formula that takes the # of cores into account?

view thread (32+ messages)  latest in thread

Message-ID: <AC5A12F0DBD14B029E00AB870776DA71@gmail.com>
Permalink:  ../AC5A12F0DBD14B029E00AB870776DA71@gmail.com/
Also on:    postgresql.org/message-id/AC5A12F0DBD14B029E00AB870776DA71@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: wplatnick@gmail.com
  Subject: Re: postgresql.conf recommendations
  In-Reply-To: <AC5A12F0DBD14B029E00AB870776DA71@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox