pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSimulating Postgresql clients
5+ messages / 5 participants
[nested] [flat]
* Simulating Postgresql clients
@ 2014-01-29 08:32 Rafiqul Haque <rafiq.ced@gmail.com>
0 siblings, 3 replies; 5+ messages in thread
From: Rafiqul Haque @ 2014-01-29 08:32 UTC (permalink / raw)
To: pgsql-admin
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,
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Simulating Postgresql clients
@ 2014-01-29 08:36 Raghavendra <raghavendra.rao@enterprisedb.com>
parent: Rafiqul Haque <rafiq.ced@gmail.com>
2 siblings, 0 replies; 5+ messages in thread
From: Raghavendra @ 2014-01-29 08:36 UTC (permalink / raw)
To: Rafiqul Haque <rafiq.ced@gmail.com>; +Cc: pgsql-admin
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.
http://wiki.postgresql.org/wiki/Pgbenchtesting
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Simulating Postgresql clients
@ 2014-01-29 08:38 jaime soler <jaime.soler@gmail.com>
parent: Rafiqul Haque <rafiq.ced@gmail.com>
2 siblings, 1 reply; 5+ messages in thread
From: jaime soler @ 2014-01-29 08:38 UTC (permalink / raw)
To: Rafiqul Haque <rafiq.ced@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Simulating Postgresql clients
@ 2014-01-29 08:42 desmodemone <desmodemone@gmail.com>
parent: jaime soler <jaime.soler@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: desmodemone @ 2014-01-29 08:42 UTC (permalink / raw)
To: jaime.soler@gmail.com; +Cc: Rafiqul Haque <rafiq.ced@gmail.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Simulating Postgresql clients
@ 2014-01-29 13:24 Stephen Frost <sfrost@snowman.net>
parent: Rafiqul Haque <rafiq.ced@gmail.com>
2 siblings, 0 replies; 5+ messages in thread
From: Stephen Frost @ 2014-01-29 13:24 UTC (permalink / raw)
To: Rafiqul Haque <rafiq.ced@gmail.com>; +Cc: pgsql-admin
* 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
Attachments:
signature.asc (application/pgp-signature, 835B) download
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2014-01-29 13:24 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-01-29 08:32 Simulating Postgresql clients Rafiqul Haque <rafiq.ced@gmail.com>
2014-01-29 08:36 ` Raghavendra <raghavendra.rao@enterprisedb.com>
2014-01-29 08:38 ` jaime soler <jaime.soler@gmail.com>
2014-01-29 08:42 ` desmodemone <desmodemone@gmail.com>
2014-01-29 13:24 ` Stephen Frost <sfrost@snowman.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox