| 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: | Whole Thread | Raw Message | 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
| 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? |