| From: | "Kevin Grittner" <kgrittn(at)mail(dot)com> |
|---|---|
| To: | "Maciek Sakrejda" <m(dot)sakrejda(at)gmail(dot)com>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Out of shared mem on new box with more mem, 9.1.5 -> 9.1.6 |
| Date: | 2012-10-24 20:29:57 |
| Message-ID: | 20121024202957.306930@gmx.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2012-10-25 12:10:03 | Re: How to upgrade from 9.1 to 9.2 with replication? |
| Previous Message | Shaun Thomas | 2012-10-24 19:54:52 | Re: Setting Statistics on Functional Indexes |