Home > mailing lists

pgbench unable to scale beyond 100 concurrent connections - Mailing list pgsql-hackers

From	Sachin Kotwal
Subject	pgbench unable to scale beyond 100 concurrent connections
Date	June 29, 2016 13:48:32
Msg-id	CA+N_YAfw+97KtPqrPKz5D3vwLbgj8Oqm-5OcPuiJYN6soVBCKQ@mail.gmail.com Whole thread Raw
Responses	Re: pgbench unable to scale beyond 100 concurrent connections (Fabien COELHO <coelho@cri.ensmp.fr>) Re: pgbench unable to scale beyond 100 concurrent connections (Craig Ringer <craig@2ndquadrant.com>)
List	pgsql-hackers

Hi,

I am testing pgbench with more than 100 connections.

also set max_connection in postgresql.conf more than 100.

Initially pgbench tries to scale nearby 150 but later it come down to 100 connections and stable there.

It this limitation of pgbench? or bug? or i am doing it wrong way?

---

I tested it with max_connection = 200 in postgresql.conf

and pgbench witn -c 180/190/200

Please reply.

Thanks and Regards,

Sachin Kotwal

From: Alex Ignatov
Date: 29 June 2016, 13:43:47
Subject: Strange behavior of some volatile function like random(), nextval()

From: Michael Paquier
Date: 29 June 2016, 14:35:09
Subject: Re: Strange behavior of some volatile function like random(), nextval()