pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Extreme high load averages
Date: Sun, 06 Jul 2003 15:14:18 +0530
Message-ID: <3F083CCA.31144.7468C@localhost> (raw)
In-Reply-To: <3F07ABA1.2070100@ethereal-realms.org>
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?
HTH
Bye
Shridhar
--
Power, n.: The only narcotic regulated by the SEC instead of the FDA.
view thread (22+ messages) latest in thread
Message-ID: <3F083CCA.31144.7468C@localhost> Permalink: ../3F083CCA.31144.7468C@localhost/ Also on: postgresql.org/message-id/3F083CCA.31144.7468C@localhost ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients from your mail client; the link fills in the headers below: reply via email Some clients, webmail especially, drop In-Reply-To and References from a link, and the reply then starts a new thread: use the mbox below. To: pgsql-performance@postgresql.org Cc: shridhar_daithankar@persistent.co.in Subject: Re: Extreme high load averages In-Reply-To: <3F083CCA.31144.7468C@localhost> References: <3F07ABA1.2070100@ethereal-realms.org> <3F083CCA.31144.7468C@localhost> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox