Re: Lots of stuck queries after upgrade to 9.4

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Lots of stuck queries after upgrade to 9.4
Дата
Msg-id 55B7E7B1.8060803@iki.fi
обсуждение исходный текст
Ответ на Re: Lots of stuck queries after upgrade to 9.4  (Spiros Ioannou <sivann@inaccess.com>)
Ответы 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>)
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Postgresql upgrade from 8.4 to latest
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Postgresql upgrade from 8.4 to latest