Re: Web server to Database Taking forever - Mailing list pgsql-performance

From Scott Dunn
Subject Re: Web server to Database Taking forever
Date
Msg-id 200409301858.i8UIwZVd027480@ms-smtp-03-eri0.ohiordc.rr.com
Whole thread Raw
In response to Re: Web server to Database Taking forever  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Web server to Database Taking forever
Re: Web server to Database Taking forever
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Web server to Database Taking forever
Next
From: Edwin Eyan Moragas
Date:
Subject: Re: Web server to Database Taking forever