Re: Amazon EC2 CPU Utilization

From: Mike Bresnahan <mike(dot)bresnahan(at)bestbuy(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Amazon EC2 CPU Utilization
Date: 2010-01-28 19:02:28
Message-ID: loom.20100128T200012-671@post.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hardwick, Joe 2010-01-28 21:42:34 SET statement_timeout problem
Previous Message Giorgio Valoti 2010-01-28 18:10:46 Re: Status of submitted bugs

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2010-01-28 21:32:49 SQL question re aggregates & joins
Previous Message Joe Conway 2010-01-28 17:19:52 Re: dynamic crosstab