Horton
Menu

Re: Amazon EC2 CPU Utilization

Mike Bresnahan <mike.bresnahan@bestbuy.com>

View thread
From: Mike Bresnahan <mike.bresnahan@bestbuy.com>
To: pgsql-general@postgresql.org
Date: 2010-01-28T19:02:28Z
Lists: pgsql-bugs, pgsql-general 
Jim Mlodgenski <jimmy76 <at> gmail.com> writes:
> Let's start from the beginning. Have you tuned your postgresql.conf file? What
do you have shared_buffers set to? That would have the biggest effect on a test
like this. 

shared_buffers = 128MB
maintenance_work_mem = 256MB
checkpoint_segments = 20