On 5 Jul 2003 at 22:54, Martin Foster wrote:
> What I would like to know is.   Why?   The kernel has been compiled to 
> handle the number of concurrent connections, the server may not be the 
> best, but it should be able to handle the requests: PIII 1Ghz, 1GB 
> SDRAM, 2 IDE 20GB drives.
> I have changed settings to take advantage of the memory.  So the 
> following settings are of interest:
>       shared_buffers = 16384
>       wal_buffers = 256
>       sort_mem = 16384
>       vacuum_mem = 32768

As somebody else has already pointed out, your sort_mem is bit too high
than required. Try lowering it.

Secondly did you tune effective_cache_size?


Power, n.:      The only narcotic regulated by the SEC instead of the FDA.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to