 |  | |
| HomePrev | Chapter 12. Server Operations and Maintenance | Next |
|---|---|---|
The values of several PostreSQL configuration parameters may be changed for enhanced performance. The following table lists the default values and some suggested updates for several useful parameters:
Table 12.1. Suggested configuration values
| Parameter | Default | Suggested |
|---|---|---|
| default_statistics_target | 10 | 100 |
| work_mem | 4Mb | 128Mb |
| shared_buffers | 8Mb | 512Mb |
| effective_cache_size | 128Mb | 4Gb |