Lists: | pgsql-jdbc |
---|
From: | Christian Rengstl <tex79(at)web(dot)de> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Newbie question |
Date: | 2003-12-20 19:06:07 |
Message-ID: | 3FE49D9F.40104@web.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
Hello everyone,
I am quite new to Postgresql and JDBC and started to make my first
application to use postgresql. And here comes my doubt/question: is it
normal that it takes about 1 - 2 minutes to connect to the database? In
my case it actually does take that long, but I thought maybe I made
something wrong and you guys could give me a hint...
Thanks
Chris
From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Christian Rengstl <tex79(at)web(dot)de> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Newbie question |
Date: | 2003-12-22 19:33:28 |
Message-ID: | 1072121608.2201.86.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
Chris,
No, it isn't normal, but with the information you have provided it will
be difficult to analyze the problem.
Can you send us the operating systems involved, firewalls, etc.
Dave
On Sat, 2003-12-20 at 14:06, Christian Rengstl wrote:
> Hello everyone,
>
> I am quite new to Postgresql and JDBC and started to make my first
> application to use postgresql. And here comes my doubt/question: is it
> normal that it takes about 1 - 2 minutes to connect to the database? In
> my case it actually does take that long, but I thought maybe I made
> something wrong and you guys could give me a hint...
>
> Thanks
>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>
From: | Christian Rengstl <tex79(at)web(dot)de> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Newbie question |
Date: | 2003-12-22 20:19:41 |
Message-ID: | 3FE751DD.5030300@web.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
Hi,
my operating system is SuSE Linux 9.0 with Java 1.4.2, postgresql 7.3.4
and the jdbc driver is pg73jdbc3.jar. I don't have a firewall set up, so
there shouldn't be any problem with that. I have the driver in the
lib/ext directory of my Java VM.
Chris
>Chris,
>
>No, it isn't normal, but with the information you have provided it will
>be difficult to analyze the problem.
>
>Can you send us the operating systems involved, firewalls, etc.
>
>Dave
>On Sat, 2003-12-20 at 14:06, Christian Rengstl wrote:
>
>
>>Hello everyone,
>>
>>I am quite new to Postgresql and JDBC and started to make my first
>>application to use postgresql. And here comes my doubt/question: is it
>>normal that it takes about 1 - 2 minutes to connect to the database? In
>>my case it actually does take that long, but I thought maybe I made
>>something wrong and you guys could give me a hint...
>>
>>Thanks
>>
>>Chris
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faqs/FAQ.html
>>
>>
>>
>>
>
>
>
>
From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Christian Rengstl <tex79(at)web(dot)de> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Newbie question |
Date: | 2003-12-22 21:28:27 |
Message-ID: | 1072128507.1634.96.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
Ok, the only thing I can think of is you are doing a name lookup that is
returning, if you specify the ip address in the url does that speed it
up?
Dave
On Mon, 2003-12-22 at 15:19, Christian Rengstl wrote:
> Hi,
>
> my operating system is SuSE Linux 9.0 with Java 1.4.2, postgresql 7.3.4
> and the jdbc driver is pg73jdbc3.jar. I don't have a firewall set up, so
> there shouldn't be any problem with that. I have the driver in the
> lib/ext directory of my Java VM.
>
> Chris
>
> >Chris,
> >
> >No, it isn't normal, but with the information you have provided it will
> >be difficult to analyze the problem.
> >
> >Can you send us the operating systems involved, firewalls, etc.
> >
> >Dave
> >On Sat, 2003-12-20 at 14:06, Christian Rengstl wrote:
> >
> >
> >>Hello everyone,
> >>
> >>I am quite new to Postgresql and JDBC and started to make my first
> >>application to use postgresql. And here comes my doubt/question: is it
> >>normal that it takes about 1 - 2 minutes to connect to the database? In
> >>my case it actually does take that long, but I thought maybe I made
> >>something wrong and you guys could give me a hint...
> >>
> >>Thanks
> >>
> >>Chris
> >>
> >>
> >>---------------------------(end of broadcast)---------------------------
> >>TIP 5: Have you checked our extensive FAQ?
> >>
> >> http://www.postgresql.org/docs/faqs/FAQ.html
> >>
> >>
> >>
> >>
> >
> >
> >
> >
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>