Re: PostgreSQL 7.4.1 incredibly slow :-(

Поиск
Список
Период
Сортировка
От Carlos Moreno
Тема Re: PostgreSQL 7.4.1 incredibly slow :-(
Дата
Msg-id 3FF8D0F6.6070900@mochima.com
обсуждение исходный текст
Ответ на Re: PostgreSQL 7.4.1 incredibly slow :-(  (Doug McNaught <doug@mcnaught.org>)
Ответы Re: PostgreSQL 7.4.1 incredibly slow :-(  (Doug McNaught <doug@mcnaught.org>)
Список pgsql-general
> 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
--


В списке pgsql-general по дате отправления:

Предыдущее
От: "D. Dante Lorenso"
Дата:
Сообщение: Re:
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: PostgreSQL 7.4.1 incredibly slow :-(