From: | Andrei Lepikhov <lepihov(at)gmail(dot)com> |
---|---|
To: | Tamás PAPP <tomposmiko(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | Re: Low performance between datacenters |
Date: | 2024-07-08 07:24:53 |
Message-ID: | 5afc8016-161c-40d9-89e6-6dc36c55e1b6@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On 8/7/2024 01:17, Tamás PAPP wrote:
> hi All,
>
> I am new on the list.
> I hope someone can give me an adequate answer or good advice about my
> problem.
>
> I have a client (normally a web service, for testing the psql client) in
> GCP. There is a PSQL server in another DC. The ping response time is 20ms.
> I measured the bandwidth via scp and it is more than 1Gb/s which is more
> than enough IMO.
>
>
> The psql connection between the DCs for me was unexpectedly slow.
> I would expect a bit slower query without data ('select now()') due to
> the increased latency and somewhat similar speed of data transfer.
> What I see is that
>
> select now() increased from 0.7ms to 20ms which is OK.
> And 'select *' on a table with 3082 rows (so it's a small table)
> increased from 10ms to 800ms.
>
>
> Is this normal? Can I improve it somehow?
This subject is totally new for me, but maybe you have different
connection settings for internal and external connections? I mean - from
different networks?
--
regards, Andrei Lepikhov
From | Date | Subject | |
---|---|---|---|
Next Message | Dheeraj Sonawane | 2024-07-10 07:11:39 | Query performance issue |
Previous Message | Justin Pryzby | 2024-07-08 02:26:56 | Re: Hash Right join and seq scan |