April 2018
Intermediate to advanced
508 pages
15h 22m
English
All of the shared memory settings and the starting client settings for the database are stored in the postgresql.conf file. In PostgreSQL 8.2, a change has greatly simplified memory settings. In earlier versions, you had to know the unit for each memory related setting; some were in units of 1 KB, and some 8 KB, which was difficult to keep track of.
Nowadays, you can still set values like that, but the preferred practice is to use a memory size instead. For example, if you wanted to set the wal_buffers value that controls how much memory to use for buffering WAL data, you can do that now with a line such as the following in the postgresql.conf file:
wal_buffers = 64 KB
If you use the SHOW command to display ...
Read now
Unlock full access