Re: [ADMIN] Database performance problems

2009-12-28 Thread Scott Marlowe
On Wed, Dec 23, 2009 at 7:45 AM, Renato Oliveira wrote: > There are 100 connections open to the database server at any given time, > apparently using hibernate. > > We are using Postgres 8.2.4 compiled Update to 8.2.latest at your earliest chance. > The database size is 155GB > We have 8GB of RA

Re: [ADMIN] Database performance problems

2009-12-28 Thread Kevin Grittner
Renato Oliveira wrote: > We have a web application written in JAVA, using jaboss as a > servlet. Is the web app on the same box as the database, or separate? > There are 100 connections open to the database server at any given > time How many are typically active at peak times? You could

Re: [ADMIN] Database performance problems

2009-12-23 Thread Joshua D. Drake
On Wed, 2009-12-23 at 14:45 +, Renato Oliveira wrote: > Dear all, > > > > I have been using Postgres but I am not an expert on the subject. > > > > I would be very grateful if someone could point to the right direction > with regards this problem. > > > > We have a web application w

[ADMIN] Database performance problems

2009-12-23 Thread Renato Oliveira
Dear all, I have been using Postgres but I am not an expert on the subject. I would be very grateful if someone could point to the right direction with regards this problem. We have a web application written in JAVA, using jaboss as a servlet. There are 100 connections open to the database serv