Hi everyone,
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", "DateTime", "SignalRegisterId", "Raw" FROM
"SignalRecordsBlobs"
On Tue, Feb 23, 2021 at 8:46 AM Luca Ferrari wrote:
> I'm using sata disks, not scsi. Assuming I'm not looking at the wrong
> parameter, I wil attach a scsi disk to do the same test and see if
> something changes.
I've tested the same version of PostgreSQL, same benchmark, on a scsi
disk. However
