Re: PostgreSQL 7.4.1 incredibly slow :-(

Carlos Moreno <moreno(at)mochima(dot)com> writes:

> On the dual Athlon (Murphy had to do it in a way
> that maximizes the irony, of course! :-)), connections
> through TCP/IP take forever! Even if they're local
> connections (i.e., even if they come from 127.0.0.1)
>
> If I run psql locally, when executed without switches,
> it responds instantly (pg_hba.conf has an entry with
> "ident sameuser" for local connections).
>
> When executed with the -h localhost switch, it takes
> exactly 30 seconds to prompt me for the password,
> and once I enter the password, it takes another
> 30 seconds (*exactly* 30 seconds).

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.

-Doug