| From: | Alvaro Herrera <alvherre(at)atentus(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Matthew Kirkwood <matthew(at)hairy(dot)beasts(dot)org>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Performance Tuning Document? |
| Date: | 2002-03-28 21:35:10 |
| Message-ID: | Pine.LNX.4.44.0203281732560.1756-100000@cm-lcon1-46-187.cm.vtr.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
El Mar 28, Bruce Momjian escribio:
> Matthew Kirkwood wrote:
> > Hi,
> >
> > I'm playing with OSDB (http://osdb.sf.net/) and trying to get
> > the best numbers possible out of it.
> > Any tips and tricks available? Thus far, I have tried:
>
> Gererally, I think 1/4 RAM for shared buffers is a good start, and
> perhaps 2-4% for sort memory.
That 2-4% means 2-4% per backend, or totalled? I don't have your
experience, but I think that depends heavily on schemas and queries,
more than shared buffers.
--
Alvaro Herrera (<alvherre[a]atentus.com>)
"El Maquinismo fue proscrito so pena de cosquilleo hasta la muerte"
(Ijon Tichy en Viajes, Stanislaw Lem)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-03-28 21:37:33 | Re: Performance Tuning Document? |
| Previous Message | Bruce Momjian | 2002-03-28 21:20:40 | Re: Performance Tuning Document? |