This PR introduces several adjustments to the PostgreSQL configuration to optimize performance for environments using SSD storage.
Key Changes
random_page_cost is set to 1.1, down from the default suited for HDDs, to leverage the faster random read capabilities of SSDs.
effective_io_concurrency is increased to 200 to take advantage of SSD's higher parallel I/O capabilities. This is a significant change from the default setting, which is optimized for traditional HDDs.
These changes are aimed at harnessing the full potential of SSDs, ensuring better performance of the database system, especially in high I/O demand environments.
Purpose
This PR introduces several adjustments to the PostgreSQL configuration to optimize performance for environments using SSD storage.
Key Changes
random_page_costis set to1.1, down from the default suited for HDDs, to leverage the faster random read capabilities of SSDs.effective_io_concurrencyis increased to200to take advantage of SSD's higher parallel I/O capabilities. This is a significant change from the default setting, which is optimized for traditional HDDs.These changes are aimed at harnessing the full potential of SSDs, ensuring better performance of the database system, especially in high I/O demand environments.