Re: Web server to Database Taking forever

It is all working now.  The thing is I didn't change anything.  So do you
still think its Tomcat or the jdbc driver?

-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Josh Berkus
Sent: Thursday, September 30, 2004 12:39 PM
To: Scott Dunn
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Web server to Database Taking forever

Scott,

> 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

Sounds like it's a problem with your Tomcat and/or JDBC setup.  Try the
pgsql-jdbc mailing list for help.

--
Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match