From: Alexy Khrabrov <deliverable@gmail.com>
To: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: two memory-consuming postgres processes
Date: Fri, 2 May 2008 13:28:42 -0700
Message-ID: <D86DA06B-3E61-48A5-8812-8699B2892922@gmail.com> (raw)
In-Reply-To: <Pine.GSO.4.64.0805021619380.18755@westnet.com>
References: <A728C858-76CF-473F-917B-3C9EA4AA75CF@gmail.com>
<Pine.GSO.4.64.0805021619380.18755@westnet.com>
On May 2, 2008, at 1:22 PM, Greg Smith wrote:
> On Fri, 2 May 2008, Alexy Khrabrov wrote:
>
>> I have an UPDATE query updating a 100 million row table, and
>> allocate enough memory via shared_buffers=1500MB.
>
> In addition to reducing that as you've been advised, you'll probably
> need to increase checkpoint_segments significantly from the default
> (3) in order to get good performance on an update that large.
> Something like 30 would be a reasonable starting point.
>
> I'd suggest doing those two things, seeing how things go, and
> reporting back if you still think performance is unacceptable. We'd
> need to know your PostgreSQL version in order to really target
> future suggestions.
PostgreSQL 8.3.1, compiled from source on Mac OSX 10.5.2 (Leopard).
Saw the checkpoint_segments warning every ~20sec and increased it to
100 already. Will see what 512 MB buys me, but 128 MB was paging
miserably.
Cheers,
Alexy
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: deliverable@gmail.com, gsmith@gregsmith.com
Subject: Re: two memory-consuming postgres processes
In-Reply-To: <D86DA06B-3E61-48A5-8812-8699B2892922@gmail.com>
References: <A728C858-76CF-473F-917B-3C9EA4AA75CF@gmail.com> <Pine.GSO.4.64.0805021619380.18755@westnet.com> <D86DA06B-3E61-48A5-8812-8699B2892922@gmail.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