Postgres Pro
Downloads
Home   >   mailing lists

Re: Lots of stuck queries after upgrade to 9.4 - Mailing list pgsql-general

From Heikki Linnakangas
Subject Re: Lots of stuck queries after upgrade to 9.4
Date
Msg-id 55B7E7B1.8060803@iki.fi
Whole thread Raw
In response to Re: Lots of stuck queries after upgrade to 9.4  (Spiros Ioannou <sivann@inaccess.com>)
Responses Re: Lots of stuck queries after upgrade to 9.4  (Heikki Linnakangas <hlinnaka@iki.fi>)
Re: Lots of stuck queries after upgrade to 9.4  (Tatsuo Ishii <ishii@postgresql.org>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Postgresql upgrade from 8.4 to latest
Next
From: John R Pierce
Date:
Subject: Re: Postgresql upgrade from 8.4 to latest