Performance Tuning

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

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.

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.

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