Isn't 128MB quite low considering the "current standard" of 25% - 50% of total ram?
and
- Shared Memory
- PostgreSQL uses lots of this, view
ipcs
to prove it, the more shared memory the better as more data (tables) can be loaded. On a dedicated datbase server it's not uncommon to give half the memory to the database.
Since the first links are also mentioned on the official PostgreSQL website (http://www.postgresql.org/docs/techdocs.2) I think they should be trusted more.
- shared_buffers = N
- Set anywhere from 1/4 to 1/2 physical memory, must set kernel shared memory max first. Will see noticeable difference.
-- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böckler-Straße 2 http://www.deriva.de D-37079 Göttingen Deriva CA Certificate: http://www.deriva.de/deriva-ca.cer