I'm having a performance issue with postgresql. I'm using it with JBoss BPM api and when I use the api to delete a process instance from the database, it seems like the delete requests are taking quite a long time to delete. I've also noticed that when I execute the delete, the cpu load on the postgresql process on the server ramps up to 100%. Can someone tell me what logging I can turn on so I can figure out what is causing the high load and slow deletes? I can then use that info to tune the runtime parameters.
