Performance Tuning
Generally speaking, there are no surefire methods for obtaining optimal performance from a database system. However, there are guidelines that can assist administrators in implementing successful performance-tuning strategies.
Hardware Considerations
If you notice that your database system is consistently running at high CPU loads or that an excessive amount of hard-disk paging is occurring, it might be necessary to upgrade your hardware.
These are the four biggest hardware issues related to database performance:
RAM. Not enough RAM will result in the database constantly having to swap memory to hard disk. This expensive and time-consuming operation always incurs a performance hit.
Hard disk. Slow hard drives and controllers ...
Get PostgreSQL Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
