A single query won’t parallelize, so you’ll usually only heat up one core.
With pg12/ you should get more parallel behaviour and better utilitization of a
box that size for analytical queries.
P
> On Feb 25, 2020, at 9:04 AM, Alexander Gataric wrote:
>
> I've been using PostGIS on AWS with
Hi Alexander,
I'd suggest to check if there are differences in the execution of the query
in RDS or in the other box where the query is executed with higher
performances.
I'm specifically talking about to check the outputs of the EXPLAIN (BUFFER,
ANALYSE) of teh query executed in the two boxes.
I've been using PostGIS on AWS with low CPU utilization. I tried 11.6 and 10.11
and RDS size db.m5.2xlarge (8 vCPU, 32 GB).
Any suggestions? Performance is not what I'd expect from a box with those specs.
Get BlueMail for Android
On Feb 25, 2020, 10:34 AM, at 10:34 AM, Alexander Gataric