Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W8V7S-0007a5-Gu for pgsql-admin@arkaria.postgresql.org; Wed, 29 Jan 2014 13:23:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1W8V7S-0006J1-03 for pgsql-admin@arkaria.postgresql.org; Wed, 29 Jan 2014 13:23:54 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W8V7Q-0006HF-IG for pgsql-admin@postgresql.org; Wed, 29 Jan 2014 13:23:52 +0000 Received: from tamriel.snowman.net ([2001:4830:167b::11]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W8V7N-00057X-Rj for pgsql-admin@postgresql.org; Wed, 29 Jan 2014 13:23:51 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id C7F895F7B2; Wed, 29 Jan 2014 08:24:35 -0500 (EST) Date: Wed, 29 Jan 2014 08:24:35 -0500 From: Stephen Frost To: Rafiqul Haque Cc: pgsql-admin@postgresql.org Subject: Re: Simulating Postgresql clients Message-ID: <20140129132435.GC31026@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="yEuxjfeaz4aFLPvI" Content-Disposition: inline In-Reply-To: X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.8.0-35-generic (x86_64) X-Uptime: 08:22:33 up 21 days, 10:36, 7 users, load average: 0.04, 0.03, 0.05 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -2.4 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --yEuxjfeaz4aFLPvI Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * 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 the= re > is any ready tool which I could use. I googled a lot however literally, I > did not find anything. >=20 > 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 --yEuxjfeaz4aFLPvI Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iQIcBAEBAgAGBQJS6QETAAoJEO1sijiDR2RVhrkQAI5BOIjsOJtsWYOBuFGwtuw7 TjQlPBgdmvYYKX0jmp8fBI/+kq6S47zbmkXfRMrIfOf3PN3158Td80AVjBatoFLD Ychybri/eYuuO9SeHq9IPF1vpdZIE7GpUKXgPlkD4v01sgPbqqpGuU00UrqPv6GI M8w6+f50vXmShTpEXYRP0XTje5DqN+nlLLqkIWPF7ZVRj+glyLy5vRs1+2tHRP9D 065C3s+w/bfcfUDU83+vZxHjJPI9Lta1cwUkDX6TCvurf6ZYXAdF8rsA2OovPjBF AICfBUU2nNx5bd7zYwJCekV0c03QuhmUUJsbNsZt5rl4OkgCTNKPEiunso01V9dC D4NKx03KFOxzB2S9EG6eFRwXrE6LB2dg1E/ktuL+mxaJUC2abwj87VS43mxc3orF FsmE0yi9YVbdUzFQ6Imd/FznFOqb5ehQflz7GAcgTLcT68hktheV9Ge6/eNUiLOy 6lmBtmftqfM6vVc9vngIHAKKLllxFSMmN7+GkRtKZWCStIc4YkLSY0nfyb5YfCEr oy8UhlFBPDpPOxnb9poQCd32wAv6DjM1LProvoGOgnvUWdsaU13M6zr9dksMpnVi 4gNWoysxjy8jrzwgVAthx3z9wCqqkVv1k/c0hleMcvY4B7db8UzbZBtr+2tYPqTA J4JTzOw9JSegaB2PauWw =Jxdu -----END PGP SIGNATURE----- --yEuxjfeaz4aFLPvI--