public inbox for [email protected]
help / color / mirror / Atom feedFrom: Andrei Lepikhov <[email protected]>
To: Tamás PAPP <[email protected]>
To: [email protected]
Subject: Re: Low performance between datacenters
Date: Mon, 8 Jul 2024 14:24:53 +0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAB4oFF1EhyL2OL9jtf-SNpa=0EgH94vzF2S3awFJDFMFXruzfA@mail.gmail.com>
References: <CAB4oFF1EhyL2OL9jtf-SNpa=0EgH94vzF2S3awFJDFMFXruzfA@mail.gmail.com>
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
view thread (4+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Low performance between datacenters
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox