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

Web server to Database Taking forever

From: "Scott Dunn" <sdunn(at)tsh(dot)net>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Web server to Database Taking forever
Date: 2004-09-30 14:46:27
Message-ID: 200409301446.i8UEkZVd018812@ms-smtp-03-eri0.ohiordc.rr.com (view raw or flat)
Thread:
Lists: pgsql-performance
Sometimes when you click on a link on my site to access my postgres database
it takes forever for it to connect. You can click this link and see how long
it takes.
 <http://www.3idiots.com:8080/examples/jsp/movies/wantedlist.jsp>
http://www.3idiots.com:8080/example.../wantedlist.jsp

It doesn't do it all the time. Sometimes its really fast. I can't figure out
what is wrong. If I go on the server where the database is I can connect and
run queries with no problem. I can also access the database from Access and
run queries with no problems. It is only a problem when you come from the
web. Tomcat and apache are both working. You can see this by going here 
 <http://www.3idiots.com:8080/examples/jsp/movies/moviesearch.jsp>
http://www.3idiots.com:8080/example...moviesearch.jsp

I am using 
psql (PostgreSQL) 7.2.1
tomcat 4.0.1
apache-1.3.9-4
Redhat linux 6.2

Does anyone know what I can check to see what is causing this. It seemed to
have happened all of sudden one day. I don't know what could have changed to
cause this. I have rebooted the server and it still happens. Any help will
be greatly appreciated.

Also I need to add that I never get an error message. It just sits there for
quite some time. Eventually it will work.

 
Scott 
 
Scott Dunn
The Software House, Inc.
513.563.7780
 

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2004-09-30 14:54:50
Subject: Re: [HACKERS] spurious function execution in prepared statements.
Previous:From: Stephan SzaboDate: 2004-09-30 14:45:40
Subject: Re: spurious function execution in prepared statements.

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