Re: Postgresql Performance Issue (deadlock) with Document Fetch

2017-01-15 Thread Chalitha Perera
Hi Karl, We have ran the load tests on Postgres as you suggested and it was completed successfully. But with Alfresco connector the job gets stuck every-time. I have opened a Jira[1] and attached jstack jump there. It was taken at the job stuck stage before giving the deadlock message. Please have

Re: Postgresql Performance Issue (deadlock) with Document Fetch

2016-12-01 Thread Karl Wright
Hi Chalitha, I have honestly never heard of anything so bizarre before. We have performance tests for some connectors that run 100,000 documents or more. If what you are encountering is postgresql related, you could try to run them against your postgresql instance and see what happens. That wou