For the moment we use a postgresql database.
Step by step we have a performance degradation, I see that the post gre sql server don't uses a lot of resources (memory, disk & cpu)
1)
So i started to dig into postgresql documentation and change some post gresql settings (memory, cache, query plan),
Still i do not see any changes in performance & resource consumption.
Question: is there documentation on how to fine tune post gre sql database?
2)
I do not see a lot of connection sessions on my database,
Question?
into the dynaTrace server we can make a database connection (Performance warehouse: connect)
Does this mean that the dynaTrace server only has one database connection to handle all client requests (in post gresql this means one thead on one cpu)? How exactly is parallelism implemented into the solution?
Thx
Answer by Andreas G. ·
Hi Steven. Just checking in whether this question might be answered with a separate forum post you have going on here: Performance warehouse: limiting size: tips and tricks?
JANUARY 15, 3:00 PM GMT / 10:00 AM ET