Re: Lots of stuck queries after upgrade to 9.4

From: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
To: Spiros Ioannou <sivann(at)inaccess(dot)com>, Andres Freund <andres(at)anarazel(dot)de>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Subject: Re: Lots of stuck queries after upgrade to 9.4
Date: 2015-07-28 20:36:01
Message-ID: 55B7E7B1.8060803@iki.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

A-ha, I succeeded to reproduce this now on my laptop, with pgbench! It
seems to be important to have a very large number of connections:

pgbench -n -c400 -j4 -T600 -P5

That got stuck after a few minutes. I'm using commit_delay=100.

Now that I have something to work with, I'll investigate this more tomorrow.

- Heikki

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2015-07-28 20:57:11 Re: Postgresql upgrade from 8.4 to latest
Previous Message John R Pierce 2015-07-28 20:35:16 Re: Postgresql upgrade from 8.4 to latest