Tuning the Database Server¶

MariaDB database

MariaDB: Tuning Server Parameters

According to this documentation, the two most important variables to configure are key_buffer_size and table_open_cache.
PostgreSQL database

PostgreSQL: Server Configuration

Read the Docs v: stable

Versions: latest; stable; 2.16.5; 2.16.4; 2.16.3; 2.16.2; 2.16.1; 2.16.0; 2.15.1; 2.15.0; 2.14.6; 2.14.5; 2.14.4; 2.14.3; 2.14.2; 2.14.1; 2.14.0; 2.13.11; 2.12; 2.11; 2.9

Downloads: pdf; html; epub

On Read the Docs: Project Home; Builds

Free document hosting provided by Read the Docs.