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

help / color / mirror / Atom feed
From: Craig Ringer <craig@postnewspapers.com.au>
To: Bob Dusek <redusek@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: performance config help
Date: Thu, 14 Jan 2010 13:45:05 +0800
Message-ID: <4B4EAF61.1030501@postnewspapers.com.au> (raw)
In-Reply-To: <61039b861001131437j4a70ab8nd68ebf0733994854@mail.gmail.com>
References: <4B4B177B020000250002E194@gw.wicourts.gov>
	<dcc563d11001111136y117ea68dp651fd24ce72385f3@mail.gmail.com>
	<4B4B3BF6020000250002E1B1@gw.wicourts.gov>
	<61039b861001111323g531a5d68q1f59171d926aefef@mail.gmail.com>
	<alpine.DEB.2.00.1001121641360.25000@aragorn.flymine.org>
	<61039b861001121001p37dc7698i48651189edcee9d0@mail.gmail.com>
	<4B4D53BF.4020905@postnewspapers.com.au>
	<61039b861001131210j673f1200r16f60f26f5a22265@mail.gmail.com>
	<dcc563d11001131243l1a53c485s452780f9f6abb976@mail.gmail.com>
	<61039b861001131437j4a70ab8nd68ebf0733994854@mail.gmail.com>

Bob Dusek wrote:

> So, pgBouncer is pretty good.  It doesn't appear to be as good as
> limiting TCON and using pconnect, but since we can't limit TCON in a
> production environment, we may not have a choice.

It may be worth looking into pgpool, as well. If you have a very
cheap-to-connect-to local pool you can use non-persistent connections
(for quick release) and the local pool takes care of maintaining and
sharing out the expensive-to-establish real connections to Pg its self.

If you find you still can't get the throughput you need, an alternative
to adding more hardware capacity and/or more server tuning is to look
into using memcached to satisfy many of the read requests for your app
server. Use some of that 16GB of RAM on the app server to populate a
memcached instance with less-frequently-changing data, and prefer to
fetch things from memcached rather than from Pg. With a bit of work on
data access indirection and on invalidating things in memcached when
they're changed in Pg, you can get truly insane boosts to performance
... and get more real work done in Pg by getting rid of repetitive
queries of relatively constant data.

--
Craig Ringer



view thread (46+ messages)  latest in thread

Message-ID: <4B4EAF61.1030501@postnewspapers.com.au>
Permalink:  ../4B4EAF61.1030501@postnewspapers.com.au/
Also on:    postgresql.org/message-id/4B4EAF61.1030501@postnewspapers.com.au

 · 

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: craig@postnewspapers.com.au, redusek@gmail.com, scott.marlowe@gmail.com
  Subject: Re: performance config help
  In-Reply-To: <4B4EAF61.1030501@postnewspapers.com.au>

* 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