PostgreSQL系统设备优化(国外英文资料).docVIP

PostgreSQL系统配置优化 PostgreSQL system configuration optimization PG configuration file is postgresql database directory. The conf file, after the 8.0 version can support K, M, G such argument, just change the corresponding parameter after restart the PG services with respect to OK. Shared_buffers: this is the most important parameter, and postgresql deals with the kernel and disk with shared_buffers, so it should be as large as possible to allow more data to be cached in shared_buffers. It is usually reasonable to set 10% of the actual RAM, such as 50000 (400M). Giving all memory to shared_buffe