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

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Sbob <sbob(at)quadratum-braccas(dot)com>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: significant jump in sql statement timing for on server vs a remote connection
Date: 2022-04-20 04:17:14
Message-ID: CAMkU=1y3HcV5yKXHFguRDO5+7HmBtcVdQPfw-eaE-zUQdSSqSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Apr 19, 2022 at 5:00 PM Sbob <sbob(at)quadratum-braccas(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message wakandavision 2022-04-20 06:49:16 Re: Postgresql TPS Bottleneck
Previous Message Justin Pryzby 2022-04-19 21:04:21 Re: significant jump in sql statement timing for on server vs a remote connection