C.0 Best Practices for Maintaining PostgreSQL Database

You can fine-tune the database to improve the performance of the database server. The limits mentioned in this section are approximate recommendations. They are not hard limits. However, in highly dynamic systems, it is a good practice to build in buffers and allow room for growth.