Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <kgrittn@mail.com>) id 1TR7jg-00005X-T0
	for pgsql-performance@postgresql.org; Wed, 24 Oct 2012 20:39:33 +0000
Received: from mailout-us.gmx.com ([74.208.5.67] helo=mailout-us.mail.com)
	by makus.postgresql.org with smtp (Exim 4.72)
	(envelope-from <kgrittn@mail.com>) id 1TR7ja-0005r6-Ez
	for pgsql-performance@postgresql.org; Wed, 24 Oct 2012 20:39:32 +0000
Received: (qmail 14245 invoked by uid 0); 24 Oct 2012 20:29:59 -0000
Received: from 76.255.19.161 by rms-us007 with HTTP
Cc: pgsql-performance@postgresql.org
Content-Type: text/plain; charset="utf-8"
Date: Wed, 24 Oct 2012 16:29:57 -0400
From: "Kevin Grittner" <kgrittn@mail.com>
Message-ID: <20121024202957.306930@gmx.com>
MIME-Version: 1.0
Subject: Re: Out of shared mem on new box with more mem, 9.1.5 ->
 9.1.6
To: "Maciek Sakrejda" <m.sakrejda@gmail.com>,"Tom Lane" <tgl@sss.pgh.pa.us>
X-Authenticated: #138763884
X-Flags: 0001
X-Mailer: GMX.com Web Mailer
x-registered: 0
Content-Transfer-Encoding: 8bit
X-GMX-UID: kir6cIEW3zOlOQ09LnwhWJB+IGRvb4A1
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201210/301
X-Sequence-Number: 48260

Maciek Sakrejda wrote:

> Before the switch, everything was running fine.

One thing to look for is a connection stuck in "idle in transaction"
or old prepared transactions in pg_prepared_xacts. Either will cause
all sorts of problems, but if you are using serializable transactions
the error you are seeing is often the first symptom. I'm starting to
think we should add something about that to the hint.

On the other hand, it could just be that you need to increase the
setting the hint currently references. For complex databases it is
definitely on the low side. It is really low if you have tables with
hundreds of partitions which might get referenced by a single query.

-Kevin