Since this is a comparison to RDS, and the goal presumably is to make the
test as even as possible, you will want to pay attention to the network IO
capacity for the client and the server in both tests.
For RDS, you will be unable to run the client software locally on the
server hardware, so you s
Philip,
The results in first email in this thread were using explain analyze.
I thought that you asked to run using only 'explain'. My bad.
The point is, the execution time with explain analyze is less the 1 second.
But the actual execution time (calculated from the python client) is 24
seconds
Hi, Philip
We ran: EXPLAIN (FORMAT JSON) SELECT "Id", "DateTime", "SignalRegisterId",
"Raw" FROM "SignalRecordsBlobs" WHERE "SignalSettingId" = 103 AND
"DateTime" BETWEEN '2019-11-28T14:00:12.54020' AND
'2020-07-23T21:12:32.24900';
but it was really fast. I think the results were discarde
