Re: Amazon EC2 CPU Utilization - Mailing list pgsql-general

From Mike Bresnahan
Subject Re: Amazon EC2 CPU Utilization
Date
Msg-id loom.20100128T200012-671@post.gmane.org
Whole thread Raw
In response to Amazon EC2 CPU Utilization  (Mike Bresnahan <mike.bresnahan@bestbuy.com>)
Responses SET statement_timeout problem  ("Hardwick, Joe" <Joe.Hardwick@fnis.com>)
List 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


pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: dynamic crosstab
Next
From: Scott Ribe
Date:
Subject: SQL question re aggregates & joins