since nobody responded, we started to experiment.
AWS RDS Postgres 9.6.3
db.m4.xlarge (4 cores, 16 GB RAM)
provisioned iops 4000
Indexing Performance for most jobs is pretty good, except a for a bigger sharepoint crawl (~200.000 docs).
We are seeing a lot of long running queries for the tables carrydown here.
(due to this discussion we left autovac on: https://www.mail-archive.com/
CPU Usage of the Database is between 15% and 35%
Are we hitting bad auto optimiziations of the newer postgresql version?
Many thanks in advance,