From: Kevin Grittner <kgrittn@mail.com>
To: Maciek Sakrejda <m.sakrejda@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Out of shared mem on new box with more mem, 9.1.5 -> 9.1.6
Date: Wed, 24 Oct 2012 16:29:57 -0400
Message-ID: <20121024202957.306930@gmx.com> (raw)
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
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: kgrittn@mail.com, m.sakrejda@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: Out of shared mem on new box with more mem, 9.1.5 -> 9.1.6
In-Reply-To: <20121024202957.306930@gmx.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