Re: tuning on ec2 - Mailing list pgsql-performance

From Josh Berkus
Subject Re: tuning on ec2
Date
Msg-id 4DCC76E3.2080204@agliodbs.com
Whole thread Raw
In response to Re: tuning on ec2  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-performance
> Sounds like a reasonable starting point.  You could certainly fiddle
> around a bit - especially with shared_buffers - to see if some other
> setting works better, but that should be in the ballpark.

I tend to set it a bit higher on EC2 to discourage the VM from
overcommitting memory I need.  So, I'd do 2.5GB for that one.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: 'Interesting' prepared statement slowdown on large table join
Next
From: Greg Smith
Date:
Subject: Re: Checkpoint execution overrun impact?