Re: Low Budget Performance, Part 2

Laurette Cisneros wrote:
>
> Hi,
>
> Speaking of which, what is the recommended optimum setting for
> memory buffers?

Hi Laurette,

It depends on how much memory you have, how big your database is, the
types of queries, expected number of clients, etc.

It's just that the default settings commonly cause non-optimal
performance and massive CPU utilisation, so I was wondering.

:-)

Regards and best wishes,

Justin Clift


> Thanks,
>
> L.
> On Thu, 28 Nov 2002, Justin Clift wrote:
> >
> > Hmmm..... Eric, have you tuned PostgreSQL's memory buffers at all?
> >
> > :-)
> >
> > Regards and best wishes,
> >
> > Justin Clift
> >
> >
> > <snip>
> >
> >
>
> --
> Laurette Cisneros
> The Database Group
> (510) 420-3137
> NextBus Information Systems, Inc.
> www.nextbus.com
> ----------------------------------
> My other vehicle is my imagination.
>  - bumper sticker

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi