Em qua., 20 de abr. de 2022 às 12:16, Sbob
escreveu:
>
> On 4/19/22 22:17, Jeff Janes wrote:
>
> On Tue, Apr 19, 2022 at 5:00 PM Sbob 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 pin
On 4/19/22 22:17, Jeff Janes wrote:
On Tue, Apr 19, 2022 at 5:00 PM Sbob 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 networ
On Tue, Apr 19, 2022 at 5:00 PM Sbob 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
On Tue, Apr 19, 2022 at 03:00:09PM -0600, Sbob wrote:
> We are debugging a sql performance issue. We have a sql file with 50,000
> simple select statements in it. If I run the file locally it completes in
> less than 15sec. If I force the local connection to be a tcp/ip connection
> via psql -h an
Hi all;
We are debugging a sql performance issue. We have a sql file with 50,000
simple select statements in it. If I run the file locally it completes
in less than 15sec. If I force the local connection to be a tcp/ip
connection via psql -h and I get approximately the same results, 15 - 16s
