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




Reply via email to