Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 66D7E2E0030 for ; Sun, 17 Feb 2008 12:21:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 43562-06 for ; Sun, 17 Feb 2008 12:21:04 -0400 (AST) Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.185]) by postgresql.org (Postfix) with ESMTP id A001E2E002C for ; Sun, 17 Feb 2008 12:21:00 -0400 (AST) Received: by rv-out-0910.google.com with SMTP id g13so1118292rvb.43 for ; Sun, 17 Feb 2008 08:20:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; bh=97A1wuCuuPHq8p1DIN3x8kuHLqFxvtkISJ2apG1xyTQ=; b=vvDxnRitrnKEG3FgWVXS/Ri0GnD9/UemdBVIjYAX0LpWBfQ98Y8uRH4iwZC8SjI1EJMgqsGWMnq1jmzxfj62vyPIOvVuOuR4xKWmU7ESGwIxwcne4tdUNbRRW+opKnTSjgBEUwHjThZMlED1PzInOhxHcA7ynCSklsBRwZJDpBw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=YrsIp+LvJnwHv9Xs/YRBeKHhXKf6LbxMpZclUQpU+KIoqr8jbaG5Zvvvo7v4VZTdMbXiWkfZQqD+zoIxegEELxcB0NaGd015Z2m80+2o6DvjaurchfszpDYxmMa6ZaCCHFL+NGp8IEK3Tyg2YtrOzw+4H2znE0YIVHh7dWDdS4s= Received: by 10.141.96.21 with SMTP id y21mr3222871rvl.132.1203265259189; Sun, 17 Feb 2008 08:20:59 -0800 (PST) Received: from ?192.168.3.148? ( [68.79.189.145]) by mx.google.com with ESMTPS id l43sm9496558wrl.26.2008.02.17.08.20.54 (version=SSLv3 cipher=RC4-MD5); Sun, 17 Feb 2008 08:20:55 -0800 (PST) Subject: Re: Example web access to Postgres DB From: Adam Tauno Williams Reply-To: adamtaunowilliams@gmail.com To: pgsql-performance In-Reply-To: <20080217101814.f01b2a26.wmoran@collaborativefusion.com> References: <2e5ec3f0802170321m704415e9oa926eada411b0164@mail.gmail.com> <20080217101814.f01b2a26.wmoran@collaborativefusion.com> Content-Type: text/plain Date: Sun, 17 Feb 2008 11:22:21 -0500 Message-Id: <1203265341.5435.23.camel@aleph.morrison.iserv.net> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/195 X-Sequence-Number: 28737 > > I am looking for an example of a web application (WAR) which executea a > > Postgres actions. This aims to test the performance of Postgres in Web mode. > > I shall be grateful if someone gives me a link where I can find a WAR file. > I think you're going to have to be more specific. I don't know what > technology uses WAR files, and based on the tepid response, it doesn't > seem like anyone else on the list does either. > What program are you using that uses the WAR files? WAR is a way of packaging J2EE applications for Java app servers like Tomcat, JBoss, etc... I have no idea what the question is looking for; there are hundreds, if not thousands, of J2EE applications that use PostgreSQL (OpenNMS, OpenReports, OpenBravo, JOPE,....). And likely 100% of those connect via JDBC with entirely standard and fairly database-agnostic code. And I think a "performance test" from a J2EE application is just as likely to measure the performance of the particular J2EE platform [and configuration] then it is to tell you much about PostgreSQL performance. For performance testing (of the JDBC driver/connection) it would be better to connect from a simple Java application (without any of the app server overhead) otherwise you have no idea who/what you are measuring [unless your a J2EE guru]. -- Adam Tauno Williams, Network & Systems Administrator Consultant - http://www.whitemiceconsulting.com Developer - http://www.opengroupware.org