Re: PostgreSQL 7.4.1 incredibly slow :-(

> One possibility (though I'm a bit dubious about it in your case) is a
> reverse DNS lookup on the server side that is timing out. You might
> do a
>
> $ dig -x client.ip.address
>
> on the server and see how long it takes.

Wow!! You guys are really good! (same goes for Martijn)

After doing some more testing, I actually reached this same
conclusion. I contacted our hosters to follow-up on this,
but the problem was solved (temporarily) by putting the
three hosts in the /etc/hosts file of each of the machines.

I do find it strange that reverse DNS lookups are required
under normal conditions (I mean, I did telnet 1.2.3.4 22
and it would take a while -- after I included the host name
and its IP address 1.2.3.4 in the /etc/hosts, the delay
just went away). Don't understand why this happens, but
in any case it would seem like PostgreSQL's communications
protocol has nothing to do with the problem.

Thanks!

Carlos
--