| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> |
| Cc: | "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: very, very slow performance |
| Date: | 2009-02-21 21:39:32 |
| Message-ID: | dcc563d10902211339g22e61e8dp914d0a21900b8ec6@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sat, Feb 21, 2009 at 3:11 AM, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Mayer | 2009-02-21 22:41:13 | Re: 8.3.5 broken after power fail SOLVED |
| Previous Message | Tena Sakai | 2009-02-21 18:45:45 | Re: very, very slow performance |