Performance Tuning

This is a first-release of the documentation. Additional detail will be added as the project matures.

These are RECOMMENDATIONS ONLY based on our own internal testing. Do not blindly implement these recommendations without performing your own testing first.

Vacuum - We recommend performing a VACUUM daily during idle hours as well as an infrequent VACUUM FULL.

Analyze - We recommend performing an ANALYZE on a daily basis. This can be done in conjunction with the daily VACUUM.

Reindex - A periodic REINDEX may be required to remove index bloat.

shared_buffers - The default shared_buffers setting in Postgres is low. If your server will be doing primarily database work, you can up the shared_buffers to be between 20% - 25% of the total system memory. You may need to play with this setting to see what works best for you.

wal_buffers - The default write-ahead log setting in Postgres is low. We recommending increasing it to 8MB.

effective_cache_size - This can be set to 50% - 75% of your available system memory.

log_min_duration_statement - This feature in Postgres will log each query/command and its run-time. This can be very useful to identify slow-running queries. Logging "all" commands can be too much load on the server. We recommend logging only commands that take longer than 10 seconds to run. The information collected can be used to determine if indices need to be created or if additional maintenance is required.

Indices - A large part of database tuning is in the indexes themselves. We have created indices for the most common queries we feel will be executed on the database but individual installations will still require site-specific tuning. The need for this type of tuning will increase as your call volume increases.

Delete Expired Rate Sheets - Deleting rate sheets/decks that have expired will improve performance as there will be fewer records to process during rating.

Follow us on twitter to receive new feature notifications: http://www.twitter.com/opencdrrate/

Join our LinkedIn group to open discussions on features you would like to see in the system. http://www.linkedin.com/groups/OpenCDRRate-4381972