Postgres Pro
Downloads
Home   >   mailing lists

significant jump in sql statement timing for on server vs a remote connection - Mailing list pgsql-performance

From Sbob
Subject significant jump in sql statement timing for on server vs a remote connection
Date
Msg-id ddbdea4b-f071-c0fd-d645-2724f489bc77@quadratum-braccas.com
Whole thread Raw
Responses Re: significant jump in sql statement timing for on server vs a remote connection  (Justin Pryzby <pryzby@telsasoft.com>)
Re: significant jump in sql statement timing for on server vs a remote connection  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Patil, Ravi"
Date:
Subject: How to find all SQLs executed by a transaction id?
Next
From: Justin Pryzby
Date:
Subject: Re: significant jump in sql statement timing for on server vs a remote connection