On Sun, 26 Aug 2007 00:39:52 +0400, Martijn van Oosterhout
<kleptog@xxxxxxxxx> wrote:
On Sun, Aug 26, 2007 at 01:22:58AM +0400, Max Zorloff wrote:
Hello.
shared_memory is used for caching. It is filled as stuff is used. If
you're not using all of it that means it isn't needed. Remember, it is
not the only cache. Since your database is only 400MB it will fit
entirely inside the OS disk cache, so you really don't need much shared
memory at all.
Loading stuff into memory for the hell of it is a waste, let the system
manage the memory itself, if it needs it, it'll use it.
Where do I find my OS disk cache settings? I'm using Linux.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
