Re: tuning on ec2

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: tuning on ec2
Date: 2011-05-13 00:10:11
Message-ID: 4DCC76E3.2080204@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2011-05-13 02:10:32 Re: Checkpoint execution overrun impact?
Previous Message Jeff Janes 2011-05-12 23:28:42 Re: 'Interesting' prepared statement slowdown on large table join