Space: Apache Connectors Framework (https://cwiki.apache.org/confluence/display/CONNECTORS)
Page: How to Build and Deploy ManifoldCF (https://cwiki.apache.org/confluence/display/CONNECTORS/How+to+Build+and+Deploy+ManifoldCF)
Comment: https://cwiki.apache.org/confluence/display/CONNECTORS/How+to+Build+and+Deploy+ManifoldCF?focusedCommentId=24185962#comment-24185962
Comment added by Farzad:
---------------------------------------------------------------------
I didn't see any instructions talking about the need to increase the number of worker threads.
Where is that listed?
Something doesn't add up, reading the conf, so each connection costs 400 bytes, each lock
cost 270 bytes. The default max lock is 10 per connection.
10 x 400 x 270 = 1,080,000
400 x 400 = 160,000
Total shared memory needed = 1,240,000 bytes = which is 1.2 MB, we are setting the shared
memory to 1024MB, almost a 1000 more. Why would there be a problem?
The other angle is I configured Postgre to have 400 connection but MCF is set to 30, not even
close.
Something is missing :)
In reply to a comment by Karl Wright:
The problem is that you also need to increase the amount of shared memory buffers for PostgreSQL
when you increase the max number of connections. There is a formula in the postgresql.conf
file.
If you haven't completely followed the instructions and haven't actually increased the number
of worker threads, however, you do not need to set the max number of connections to anything
other than their default of 100.
Change your notification preferences: https://cwiki.apache.org/confluence/users/viewnotifications.action
|