Re: Performance Tuning Document? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Performance Tuning Document?
Date
Msg-id Pine.LNX.4.44.0203281732560.1756-100000@cm-lcon1-46-187.cm.vtr.net
Whole thread Raw
In response to Re: Performance Tuning Document?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Performance Tuning Document?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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)


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Performance Tuning Document?
Next
From: Bruce Momjian
Date:
Subject: Re: Performance Tuning Document?