From: Rob <rclemley@yahoo.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: System overload / context switching / oom, 8.3
Date: Tue, 02 Feb 2010 15:44:36 -0600
Message-ID: <4B689CC4.8010406@yahoo.com> (raw)
In-Reply-To: <dcc563d11002021225v757f48c8i9faee286f82f703f@mail.gmail.com>
References: <4B6878DF.3000004@yahoo.com>
<dcc563d11002021225v757f48c8i9faee286f82f703f@mail.gmail.com>
Scott Marlowe wrote:
> On Tue, Feb 2, 2010 at 12:11 PM, Rob <rclemley@yahoo.com> wrote:
>
>> postgresql.conf:
>> max_connections = 1100
>> work_mem = 32MB
>>
>
> 32MB * 1000 = 32,000MB... And that's if you max out connections and
> they each only do 1 sort. If you're running many queries that run > 1
> sorts it'll happen a lot sooner.
>
> Either drop max connections or work_mem is what I'd do to start with.
> If you have one or two reporting apps that need it higher, then set it
> higher for just those connections / users
Thanks much. So does dropping work_mem to the default of 1MB sound good?
By moving databases around we're getting max_connections below 600 or 700.
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rclemley@yahoo.com, scott.marlowe@gmail.com
Subject: Re: System overload / context switching / oom, 8.3
In-Reply-To: <4B689CC4.8010406@yahoo.com>
* 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