AnsweredAssumed Answered

Alfresco starting slow with PGPool

Question asked by tobix10 on Jul 16, 2013
Hello, I am trying to resolve problem with very slow startup(around 20min) when alfresco(on tomcat 7) is connected to PGPool II. I've tested direct connection from alfresco to master db and then it starts in 5 minutes.

Finally when system is loaded everything works great… I can't figure out what is wrong. Maybe some alfresco settings related with db connection interfere with pgpool ?

Configuration:
I have 2 postgres servers and pgpool configured with master-slave and load balancing modes. PGPool connects to database servers using ssh tunnels.
I set in pgpool max_pools = 2, num_init_children=512 and in postgres a few memory related settings to values which were recommended in topics I had found on the web.

Also tried pgpool to work without ssh, but it doesn't change anything.

I've noticed that most of the time it takes when JobExecutor starts acquring jobs.

Thanks in advance.

Outcomes