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

From: Sbob <sbob(at)quadratum-braccas(dot)com>
To: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: significant jump in sql statement timing for on server vs a remote connection
Date: 2022-04-19 21:00:09
Message-ID: ddbdea4b-f071-c0fd-d645-2724f489bc77@quadratum-braccas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 - 16sec.

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. Are there any
postgres specific issues / settings / connection overhead  we should
look at? Or is this simply a network issue and fully outside the scope
of the postgres database?

FYI:

postgresql 13

1.5TB of RAM

512GB of buffer_pool

10GB of work_mem

Thanks in advance

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2022-04-19 21:04:21 Re: significant jump in sql statement timing for on server vs a remote connection
Previous Message Patil, Ravi 2022-04-19 12:35:21 How to find all SQLs executed by a transaction id?