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

Re: Web server to Database Taking forever

From: "Scott Dunn" <sdunn(at)tsh(dot)net>
To: "'Josh Berkus'" <josh(at)agliodbs(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Web server to Database Taking forever
Date: 2004-09-30 18:58:27
Message-ID: 200409301858.i8UIwZVd027480@ms-smtp-03-eri0.ohiordc.rr.com (view raw or flat)
Thread:
Lists: 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(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Josh Berkus
Sent: Thursday, September 30, 2004 12:39 PM
To: Scott Dunn
Cc: pgsql-performance(at)postgresql(dot)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


In response to

Responses

pgsql-performance by date

Next:From: Edwin Eyan MoragasDate: 2004-09-30 19:17:10
Subject: Re: Web server to Database Taking forever
Previous:From: Josh BerkusDate: 2004-09-30 16:39:04
Subject: Re: Web server to Database Taking forever

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