pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Tena Sakai <tsakai@gallo.ucsf.edu>
Cc: Uwe C. Schroeder <uwe@oss4u.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: very, very slow performance
Date: Sat, 21 Feb 2009 14:39:32 -0700
Message-ID: <dcc563d10902211339g22e61e8dp914d0a21900b8ec6@mail.gmail.com> (raw)
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C0378F77A@egcrc-ex01.egcrc.org>
References: <FE44E0D7EAD2ED4BB2165071DB8E328C0378F760@egcrc-ex01.egcrc.org>
	<dcc563d10902192148s7f781086p1c0a469e0ebc1dc5@mail.gmail.com>
	<FE44E0D7EAD2ED4BB2165071DB8E328C0378F774@egcrc-ex01.egcrc.org>
	<200902202145.49391.uwe@oss4u.com>
	<dcc563d10902210057k329f93bat76d07ba0016a24fe@mail.gmail.com>
	<FE44E0D7EAD2ED4BB2165071DB8E328C0378F77A@egcrc-ex01.egcrc.org>

On Sat, Feb 21, 2009 at 3:11 AM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:
> Hi Scott,
>
> Thanks for clustering suggestion.  I have never used
> cluster command and I need to read up before I can
> use it.
>
> I have adjusted postgres parameters per your recommen-
> dation.  Work_mem is now 8GB, checkpoint_segments is
> raised to 100.  Shared_buffers is still at 1GB because
> this is bound by SHMMAX of kernal, which I cannot alter
> for maybe a few days.  I am thinking of setting SHMMAX
> to 8GB.

Yeah, I'd reverse those two and set work_mem to something in the 512M
range max.  keep in mind work_mem is per query / per sort.  4 queries
with3 sorts each = max allocation of work_mem*3*4...

 I may or may not be able to move up to 8.3.6

> over this weekend.  If not, sometime during the week.

definitely a good idea.



view thread (13+ messages)

Message-ID: <dcc563d10902211339g22e61e8dp914d0a21900b8ec6@mail.gmail.com>
Permalink:  ../dcc563d10902211339g22e61e8dp914d0a21900b8ec6@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10902211339g22e61e8dp914d0a21900b8ec6@mail.gmail.com

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott.marlowe@gmail.com, tsakai@gallo.ucsf.edu, uwe@oss4u.com
  Subject: Re: very, very slow performance
  In-Reply-To: <dcc563d10902211339g22e61e8dp914d0a21900b8ec6@mail.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