Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL->JDBC->Tomcat->Apache resource uses

From: Nikk Anderson <Nikk(dot)Anderson(at)parallel(dot)ltd(dot)uk>
To: "'nickf(at)ontko(dot)com'" <nickf(at)ontko(dot)com>, Psql-Jdbc <pgsql-jdbc(at)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PostgreSQL->JDBC->Tomcat->Apache resource uses
Date: 2001-11-14 08:20:19
Message-ID: DA1274E682D3734B8802904A9B36124C0F9359@nic-nts1.nic.parallel.ltd.uk (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-jdbc
Hi, 
I have a set up where we use just that which you describe.  We have the
addition of having some heavy duty server software populatining the database
continually.  User access the results via apache->tomcat->jdbc->postgres.

In our backend software we keep two persistant connections to the DB for all
read/write activity (one for each), which result in separate OS processes
for each.  From the web interface, there are several, but as each connection
is for often single queries, not many connections (or processes) ever build
up.  The better way to do it from tomcat is to set up a connection pool,
that way you can keep connection amounts down, so that you dont overload the
db server.

Our set up is postgres and on java server reader/writer app on a Sun Netra
X1, with 40Gb space, and 512mb memory.  Tomcat and apache are on another Sun
Netra X1 machine.  We have had no problems yet, and the database is getting
bigger all the time.

In our test environment though we did encounter problems if we ran all the
componants on a single machine with 128 Mb of physical memory.  We kept
getting IO delays as each processes was reading/writing to swap (I think)
which made the system unusable after a while, as the IO wait was pushing 80%
most of the time.  As soon as we stopped any particular process, and less
swap space was required the problem was diminished.

Hope that helps

Nikk Anderson


-----Original Message-----
From: Nick Fankhauser [mailto:nickf(at)ontko(dot)com]
Sent: 13 November 2001 19:56
To: Psql-Jdbc; pgsql-admin
Subject: PostgreSQL->JDBC->Tomcat->Apache resource uses

And finally, if anyone else is running PostgreSQL->JDBC->Tomcat->Apache, I'm
curious about your hardware configuration & experiences with it. Any
mistakes that you can help me avoid?

Thanks everyone!

-Nick

--------------------------------------------------------------------------
Nick Fankhauser  nickf(at)ontko(dot)com  Phone 1.765.935.4283  Fax 1.765.962.9788
Ray Ontko & Co.     Software Consulting Services     http://www.ontko.com/

pgsql-admin by date

Next:From: tonyDate: 2001-11-14 08:23:40
Subject: Re: PostgreSQL->JDBC->Tomcat->Apache resource uses
Previous:From: Andrew HillDate: 2001-11-13 21:48:35
Subject: Re: Freeing Connections

pgsql-jdbc by date

Next:From: tonyDate: 2001-11-14 08:23:40
Subject: Re: PostgreSQL->JDBC->Tomcat->Apache resource uses
Previous:From: Antonio Fiol BonnĂ­nDate: 2001-11-14 08:17:59
Subject: Re: [GENERAL] Storing a tree

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group