Thread: Simulating Postgresql clients
Hi,
I would be grateful anyone have a suggestion for my problem. I want to simulate 400 clients sending queries to my Postgresql server. I know the only option is developing the simulator by myself. I was wondering if there is any ready tool which I could use. I googled a lot however literally, I did not find anything.Regards,Does anyone have an advise for me?Hi,I would be grateful anyone have a suggestion for my problem. I want to simulate 400 clients sending queries to my Postgresql server. I know the only option is developing the simulator by myself. I was wondering if there is any ready tool which I could use. I googled a lot however literally, I did not find anything.
You can use pgbench.
El mié, 29-01-2014 a las 09:32 +0100, Rafiqul Haque escribió: > Hi, > > > I would be grateful anyone have a suggestion for my problem. I want to > simulate 400 clients sending queries to my Postgresql server. I know > the only option is developing the simulator by myself. I was wondering > if there is any ready tool which I could use. I googled a lot however > literally, I did not find anything. It seems that you should google more. > > Does anyone have an advise for me? pgbench or hammerora could help you. > > > Regards, > >
2014-01-29 jaime soler <jaime.soler@gmail.com>
El mié, 29-01-2014 a las 09:32 +0100, Rafiqul Haque escribió:> Hi,It seems that you should google more.
>
>
> I would be grateful anyone have a suggestion for my problem. I want to
> simulate 400 clients sending queries to my Postgresql server. I know
> the only option is developing the simulator by myself. I was wondering
> if there is any ready tool which I could use. I googled a lot however
> literally, I did not find anything.>pgbench or hammerora could help you.
> Does anyone have an advise for me?
>
>
> Regards,
>
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
+1 for HammerDB ( ex hammerora ) http://hammerora.sourceforge.net/about.html
* Rafiqul Haque (rafiq.ced@gmail.com) wrote:
> I would be grateful anyone have a suggestion for my problem. I want to
> simulate 400 clients sending queries to my Postgresql server. I know the
> only option is developing the simulator by myself. I was wondering if there
> is any ready tool which I could use. I googled a lot however literally, I
> did not find anything.
>
> Does anyone have an advise for me?
Unless your server has 400 CPUs, you probably want to use a connection
pooler in front of PG.
Thanks,
Stephen