As it happens I have years of experience configuring, tuning and managing postgresql database servers and, upon looking at the included postgresql.conf file embedded with PMP can see that it's basically just the default config.      No one remotely familiar with postgresql would think that the default config that ships with postgres is suitable for a production environment.

Are there any recommendations from ManageEngine on how this config ought to be adjusted to optimize performance?    I've been playing around with settings on my own but, while I know postgresql, I suspect other folks here might know more about how PMP actually uses the database.   I'm sure the software can perform better than what I'm seeing right now where, for example, an attempt to delete 100 resources has resulted in a select query against the database hanging for now more than 15 minutes and counting.

At this rate, it will take me all day just to delete a bunch of assets that were imported incorrectly.

thanks for any clarity or assistance anyone can provide.