Message-ID: <51D43ECE.2030804@consistentstate.com>
Date: Wed, 03 Jul 2013 10:10:06 -0500
From: David Carpio <davidc@consistentstate.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20130514 Thunderbird/17.0.6
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: My changes in the postgresql.conf does not work
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

I have made some changes in my postgresql.conf, well, I made two changes 
in this file. the first time, my queries had improved on their execution 
time considerably but in the second change, I seem my queries have not 
improved on the contrary they have come back to be slow or at best, they 
have not changed in its previous improvement.

These are my changes:

+ shared_buffers = 4GB.
+ bgwriter_lru_maxpages = 250.
+ synchronous_commit = off.
+ effective_io_concurrency = 3.
+ checkpoint_segments = 64.
+ checkpoint_timeout = 45min
+ logging_collector = on
+ log_min_duration_statement = 500
+ log_temp_files = 0.

my max connections are 150

Please, what would be my error?

Thank you for the tips,

David Carpio


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance