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