Re: Tuning for mid-size server

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Tuning for mid-size server
Date: 2003-10-21 21:11:17
Message-ID: Pine.LNX.4.33.0310211509220.10899-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 21 Oct 2003, Andrew Sullivan wrote:

> On Tue, Oct 21, 2003 at 11:51:02AM -0700, Josh Berkus wrote:
>
> > Of course, if you have anecdotal evidence to the contrary, then the
> > only way to work this would be to have OSDL help us sort it out.
>
> Nope. I too have such anecdotal evidence that 25% is way too high.
> It also seems to depend pretty heavily on what you're trying to
> optimise for and what platform you have. But I'm glad to hear
> (again) that people seem to think the 25% too high for most cases. I
> don't feel so much like I'm tilting against windmills.

I think where it makes sense is when you have something like a report
server where the result sets may be huge, but the parellel load is load,
i.e. 5 or 10 users tossing around 100 Meg or more at time.

If you've got 5,000 users running queries that are indexed and won't be
using that much memory each, then there's usually no advantage to going
over a certain number of buffers, and that certain number may be as low
as 1000 for some applications.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Will LaShell 2003-10-21 21:27:56 Re: RAID controllers etc... was: PostgreSQL data on a NAS device ?
Previous Message Andrew Sullivan 2003-10-21 20:55:04 Re: Tuning for mid-size server