Re: Tuning for mid-size server - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Tuning for mid-size server
Date
Msg-id 200310211432.16551.josh@agliodbs.com
Whole thread Raw
In response to Re: Tuning for mid-size server  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-performance
Scott,

> 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.

I've found that that question makes the difference between using 6% & 12% ...
particularly large data transformations ... but not higher than that.  And
I've had ample opportunity to test on 2 reporting servers.    For one thing,
with very large reports one tends to have a lot of I/O binding, which is
handled by the kernel.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Tuning for mid-size server
Next
From: markw@osdl.org
Date:
Subject: analyzing postgresql performance for dbt-2