On Sat, Aug 06, 2005 at 12:38:50AM -0400, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > Your are correct in that 8.0 is doing a request first. I am running
> > Red Hat version 8.0. The difference in the way 7.2 and 8.0 resolve the
> > host option has to be because of the change from geth
[EMAIL PROTECTED] writes:
> Your are correct in that 8.0 is doing a request first. I am running
> Red Hat version 8.0. The difference in the way 7.2 and 8.0 resolve the
> host option has to be because of the change from gethostbyname to
> getaddrinfo. Is there some way I can force my mac
Hi,
On Friday 05 August 2005 16:21 [EMAIL PROTECTED] wrote:
| How might I check for that?
If it's a standard distribution kernel, try "lsmod | grep ipv6" - this will
show you if you have loaded the IPv6 module; try to remove the module
by issueing "rmmod ipv6". If that fails, you probably have
Michael Fuhr <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/04/2005 05:30 PM
To
Lowell Hought/AGL/[EMAIL PROTECTED]
cc
pgsql-general@postgresql.org
Subject
Re: [GENERAL] DNS vs /etc/hosts
On Thu, Aug 04, 2005 at 04:01:43PM -0500, [EMAIL PROTECTED]
wrote:
> I also pe
ENERAL] DNS vs /etc/hosts
Hi,
On Thursday 04 August 2005 17:13, [EMAIL PROTECTED] wrote:
| I am changing from 7.2 to 8.0 and have both installed now on various
Linux
| machines. When I use the psql command line interface with a -h
hostname,
| the connection time from 7.2 is instant whi
Hi,
On Thursday 04 August 2005 17:13, [EMAIL PROTECTED] wrote:
| I am changing from 7.2 to 8.0 and have both installed now on various Linux
| machines. When I use the psql command line interface with a -h hostname,
| the connection time from 7.2 is instant while the connection time from 8.0
| is
On Aug 4, 2005, at 2:39 PM, [EMAIL PROTECTED] wrote:Both dig and nslookup are fast on all machines. 'psql' is fast on all machines, as long as I am using the version compiled with version 7.2. It is only 'psql' compiled with version 8.0 that is slow. I don't think DNS is the problem, but rather
On Thu, Aug 04, 2005 at 06:29:46PM -0600, Michael Fuhr wrote:
> Anybody know if queries can be disabled in Linux? Lowell, if
> nobody answers here then you might need to seek help in a different
> forum. Or you could just hack the code and change AF_UNSPEC to
> AF_INET ;-)
Lowell, aside fro
On Thu, Aug 04, 2005 at 04:30:52PM -0600, Michael Fuhr wrote:
> The response to 7.2 has an ANCOUNT (number of records in the answer
> section) of 1 and an NSCOUNT (number of records in the authority
> section) of 2, whereas the response to 8.0 has an ANCOUNT of 0 and
> an NSCOUNT of 1. That dispar
On Thu, Aug 04, 2005 at 04:39:02PM -0500, [EMAIL PROTECTED] wrote:
> The difference must have to do with the functions that differ in the
> different versions of psql. In looking through the code for version 8.0
> in the file /interfaces/libpq/ip.c, the function that resolves hostname is
> "get
On Thu, Aug 04, 2005 at 04:01:43PM -0500, [EMAIL PROTECTED] wrote:
> I also performed the trace you suggested. The results are the same until
> this point, where the time for
> version 8.0 totals 0.025960 and for
> version 7.2 totals 0.009481
Those differences probably don't matter, but what co
ED]>
Sent by: [EMAIL PROTECTED]
08/04/2005 03:25 PM
To
[EMAIL PROTECTED]
cc
pgsql-general@postgresql.org
Subject
Re: [GENERAL] DNS vs /etc/hosts
On Thu, Aug 04, 2005 at 03:01:31PM -0500, [EMAIL PROTECTED]
wrote:
> I'd start by comparing the /etc/nsswitch.conf files on the var
n 8.0 attempts to get the DNS info. My Linux
kernal version is 2.4.18.
"WELTY, RICHARD"
<[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/04/2005 03:46 PM
To
[EMAIL PROTECTED],
pgsql-general@postgresql.org
cc
Subject
Re: [GENERAL] DNS vs /etc/hosts
nslookup isn
op. if
dig is fast and nslookup is slow, then you need to examine
/etc/nsswitch for foulups.
richard
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, August 04, 2005 4:29 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENER
/2005 02:29 pgsql-general@postgresql.org
> PM
Subject
>Re: [GENERAL] DNS vs /etc/hosts
>
>
>
>
>
>
>
>
>
>
> On Thu, Aug 04, 2005 at 12:04:27PM -0500, [EMAIL PROTECTED] wrote:
> > Ver
On Thu, Aug 04, 2005 at 03:01:31PM -0500, [EMAIL PROTECTED] wrote:
> I'd start by comparing the /etc/nsswitch.conf files on the various
> machines. If the second column contains "files" for passwd and hosts on
> the fast machines, and "dns" on the slow machine, then change the slow
> machine to "f
pgsql-general@postgresql.org
PM Subject
On Thu, Aug 04, 2005 at 12:04:27PM -0500, [EMAIL PROTECTED] wrote:
> Version 7.2 psql - /usr/bin/psql -d dbname -h machine1
> connection time instant
> Version 8.0 psql - /usr/local/pgsql/bin/psql -d dbname -h machine1
> conection time 15 seconds
> Version 8.0 psql - /usr/local/p
04/2005 10:56 AM
To
Lowell Hought/AGL/[EMAIL PROTECTED]
cc
pgsql-general@postgresql.org
Subject
Re: [GENERAL] DNS vs /etc/hosts
Am Donnerstag, den 04.08.2005, 10:13 -0500 schrieb
[EMAIL PROTECTED]:
>
> I am changing from 7.2 to 8.0 and have both installed now on various
> Li
On Aug 4, 2005, at 8:13 AM, [EMAIL PROTECTED] wrote:I am changing from 7.2 to 8.0 and have both installed now on various Linux machines. When I use the psql command line interface with a -h hostname, the connection time from 7.2 is instant while the connection time from 8.0 is 15 seconds. My assu
On Thu, Aug 04, 2005 at 10:13:43AM -0500, [EMAIL PROTECTED] wrote:
> I am changing from 7.2 to 8.0 and have both installed now on various Linux
> machines. When I use the psql command line interface with a -h hostname,
> the connection time from 7.2 is instant while the connection time from 8.0
Am Donnerstag, den 04.08.2005, 10:13 -0500 schrieb
[EMAIL PROTECTED]:
>
> I am changing from 7.2 to 8.0 and have both installed now on various
> Linux machines. When I use the psql command line interface with a -h
> hostname, the connection time from 7.2 is instant while the connection
> time fro
I am changing from 7.2 to 8.0 and have
both installed now on various Linux machines. When I use the psql
command line interface with a -h hostname, the connection time from 7.2
is instant while the connection time from 8.0 is 15 seconds. My assumption
is that 7.2 checks the /etc/hosts file first
23 matches
Mail list logo
