| From: | Doug Fields <dfields-pg-general(at)pexicom(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Peter A(dot) Daly" <petedaly(at)ix(dot)netcom(dot)com>, Curt Sampson <cjs(at)cynic(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Non-linear Performance |
| Date: | 2002-05-30 16:03:04 |
| Message-ID: | 5.1.0.14.2.20020530120141.02b843f8@mail.pexicom.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> >> Increasing SORT_MEM would help the constant factor, however...
> >>
> > What is the most amount of SORT_MEM it makes sense to allocate?
>
>I've never experimented with it, but certainly the standard default
>(512K = 0.5M) is pretty small for modern machines. In a 2G machine
>I might try settings around 100M-500M to see what works best. (Note
I currently use 1.4 gigs for "shared mem" in my database (out of 2G) - I
couldn't get PostgreSQL to run with more than that (it might be an OS
limit, Linux 2.2).
I also use 64 megs as a SORT_MEM setting, on the theory that 4 sorts at
once will leave just enough RAM for the rest of my system not to swap.
Cheers,
Doug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wei Wang | 2002-05-30 16:09:40 | postgresql/php/apache installation question. |
| Previous Message | Doug Fields | 2002-05-30 15:23:35 | Scaling with memory & disk planning (was Re: Non-linear Performance) |