Hello,
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.
Thank you,
Steve.
