Peter Koczan wrote: > The > basic rule of thumb for shared_buffers is 25%-50% of main memory, > enough to use main memory but leaving some to allow work_mem to do its > thing and allow any other programs to run smoothly. Tweak this as > necessary.
Another rule of thumb is that on Windows you want only very little shared_buffers, because of some performance issues with shared memory on Windows. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
