Thread: Simulating Postgresql clients

Simulating Postgresql clients

From
Rafiqul Haque
Date:
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.

Does anyone have an advise for me?

Regards,
 

Re: Simulating Postgresql clients

From
Raghavendra
Date:
On Wed, Jan 29, 2014 at 2:02 PM, Rafiqul Haque <rafiq.ced@gmail.com> wrote:
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.

Does anyone have an advise for me?

Regards,
 
You can use pgbench.

---
Regards,
Raghavendra
EnterpriseDB Corporation

Re: Simulating Postgresql clients

From
jaime soler
Date:
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,
>
>




Re: Simulating Postgresql clients

From
desmodemone
Date:



2014-01-29 jaime soler <jaime.soler@gmail.com>
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,
>
>




--
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

Re: Simulating Postgresql clients

From
Stephen Frost
Date:
* 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

Attachment