Hi, Julien
Your hypothesis about network transfer makes sense. The query returns a big
size byte array blobs.
Is there a way to test the network speed against the instances? I have
access to the network speed in gcp (5 Mb/s), but don't have access in aws
rds.
[image: image.png]
Thanks in advanc
> I expect my postgres on GPC to be at least similar to the one managed by
AWS RDS
imho:
- on Google Cloud you can test with "Cloud SQL for Postgresql" (
https://cloud.google.com/sql/docs/postgres )
- on Google Compute Engine ( VM ): you have to tune the disks ; linux ;
file system ; scheduler
Hi,
On Wed, Feb 24, 2021 at 6:14 AM Maurici Meneghetti
wrote:
>
> I have 2 postgres instances created from the same dump (backup), one on a GCP
> VM and the other on AWS RDS. The first instance takes 18 minutes and the
> second one takes less than 20s to run this simples query:
> SELECT "Id", "
Hi Maurici,
as a starting point: can you make sure your GPC instance is configured in
the same way AWS is?
Once you do it, repeat the tests, and post the outcome.
Thanks,
Milos
On Tue, Feb 23, 2021 at 11:14 PM Maurici Meneghetti <
maurici.meneghe...@bixtecnologia.com.br> wrote:
> Hi everyone,
Hi Maurici,
in my experience the key factor about speed in big queries is sequential
scan. There is a huge variance in how the system is tuned. In some cases
I cannot read more than 10 MB/s, in others I get to expect 20-40 MB/s.
But then, when things are tuned well and the parallel workers set
