ACD Performance tuning

Skip to end of metadata
Go to start of metadata

ACD Router is a single threaded PHP daemon that heavily relies on PosgreSQL database.
Profiling revealed that SQL backend tuning is critical otherwise update queries can take 100ms and performance can drop to as low as 10 calls a second.

postgreSQL tuning

/var/lib/pgsql/data/postgresql.conf

Changing these options requires

This "little" change gives 10 fold performance boost!
Labels:
None
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.