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.

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