Re: [PERFORM] Needed: Simplified guide to optimal memory configuration

2005-06-24 Thread Todd Landfried
also pleased to see that Frank WIles has taken upon himself the effort to write this guidance down for folks like me. Kudos to you all. Thanks again. Todd On Jun 15, 2005, at 2:06 AM, Todd Landfried wrote: I deeply apologize if this has been covered with some similar topic before, but

Re: [PERFORM] Needed: Simplified guide to optimal memory

2005-06-16 Thread Todd Landfried
from source. There isn't any such thing as a 'supported' package for RH7.2 anyway. -- Mark Lewis On Thu, 2005-06-16 at 07:46 -0700, Todd Landfried wrote: Yes, it is 7.2. Why? because an older version of our software runs on RH7.3 and that was the latest supported release

Re: [PERFORM] Needed: Simplified guide to optimal memory configuration

2005-06-16 Thread Todd Landfried
, Tom Lane wrote: Dennis Bjorklund <[EMAIL PROTECTED]> writes: On Wed, 15 Jun 2005, Todd Landfried wrote: NOTICE: shared_buffers is 256 This looks like it's way too low. Try something like 2048. It also is evidently PG 7.2 or before; SHOW's output hasn't looked

[PERFORM] Needed: Simplified guide to optimal memory configuration

2005-06-15 Thread Todd Landfried
I deeply apologize if this has been covered with some similar topic before, but I need a little guidance in the optimization department. We use Postgres as our database and we're having some issues dealing with customers who are, shall we say, "thrifty" when it comes to buying RAM. We tel