Re: Tuning for mid-size server

Josh Berkus <josh@agliodbs.com>

From: Josh Berkus <josh@agliodbs.com>
To: "Anjan Dave" <adave@vantage.com>, <pgsql-performance@postgresql.org>
Date: 2003-10-21T17:15:57Z
Lists: pgsql-performance
Anjan,

> I read an article that suggests you 'start' with 25% of memory for
> shared_buffers. Sort memory was suggested to be at 2-4%. Here's the
> link:
> http://www.ca.postgresql.org/docs/momjian/hw_performance/node8.html
> Maybe, I misinterpreted it.

No, I can see how you arrived at that conclusion, and Bruce is an authority.  
I'll contact him.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco