Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

On many linux distros PostgreSQL comes out of the box with an incredibly conservative configuration - it uses only 8Mb of memory! To put some more fire in its belly edit the shared_buffers parameter in postgresql.conf. The memory usage is 8KB multiplied by this value. The advice in the postgres docs is not to increase it above 1/3 of the memory on your machine.

JHU Analysis of Ingest DB Activity

...

Info
titleFor More PostgreSQL Tips

See also: