Re: Performance Tuning Document?

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)