Re: Tuning for mid-size server

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Anjan Dave" <adave(at)vantage(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Tuning for mid-size server
Date: 2003-10-21 17:15:57
Message-ID: 200310211015.57569.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2003-10-21 17:22:49 Re: Tuning for mid-size server
Previous Message Josh Berkus 2003-10-21 17:13:53 Re: Low Insert/Update Performance