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

From Josh Berkus
Subject Re: Tuning for mid-size server
Date
Msg-id 200310211015.57569.josh@agliodbs.com
Whole thread Raw
In response to Re: Tuning for mid-size server  ("Anjan Dave" <adave@vantage.com>)
Responses Re: Tuning for mid-size server
List 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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Low Insert/Update Performance
Next
From: Josh Berkus
Date:
Subject: Re: Tuning for mid-size server