Re: [PERFORM] postgres 7.4 at 100%

2004-06-28 Thread Frank Knobbe
On Mon, 2004-06-28 at 14:40, Josh Berkus wrote: > As one of the writers of that article, let me point out: > > " -- Medium size data set and 256-512MB available RAM: 16-32MB (2048-4096) > -- Large dataset and lots of available RAM (1-4GB): 64-256MB (8192-32768) " > > While this is probably a lit

Re: [PERFORM] postgres 7.4 at 100%

2004-06-27 Thread Frank Knobbe
On Sun, 2004-06-27 at 00:33, Christopher Kings-Lynne wrote: > > I upped effective_cache to 16000 KB and I could only up the > > shared_buffers to 3000. Anything more and postgres would not start. > > You need to greatly incrase the shared memory max setting on your > machine so that you can use