Re: significant jump in sql statement timing for on server vs a remote connection

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: significant jump in sql statement timing for on server vs a remote connection
Дата
Msg-id CAMkU=1y3HcV5yKXHFguRDO5+7HmBtcVdQPfw-eaE-zUQdSSqSQ@mail.gmail.com
обсуждение исходный текст
Ответ на significant jump in sql statement timing for on server vs a remote connection  (Sbob <sbob@quadratum-braccas.com>)
Ответы Re: significant jump in sql statement timing for on server vs a remote connection  (Sbob <sbob@quadratum-braccas.com>)
Список pgsql-performance
Дерево обсуждения
On Tue, Apr 19, 2022 at 5:00 PM Sbob <sbob@quadratum-braccas.com> wrote:

However if we move the file to another server in the same network and
run with a psql -h then it runs for more than 10min.

What is the ping time?  Packet loss? You can't take for granted that the network is good and fast just because they are on the same LAN.

Cheers,

Jeff

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: significant jump in sql statement timing for on server vs a remote connection
Следующее
От:
Дата:
Сообщение: Re: Postgresql TPS Bottleneck