Horton

Re: Feature proposal

Steve Clark <sclark@netwolves.com>

View thread View on postgr.es
From: Steve Clark <sclark@netwolves.com>
To: jd@commandprompt.com, pgsql <pgsql-general@postgresql.org>
Date: 2010-08-25T17:06:46Z
Lists: pgsql-general 
On 08/25/2010 12:30 PM, Joshua D. Drake wrote:
> On Wed, 2010-08-25 at 12:20 -0400, Eric Comeau wrote:
>>
>>> Without even changing any line of data or code in sql !
>>>
>>> Incredible, isn't it ?
>>>
>>
>> Curious- what postgresql.conf settings did you change to improve it?
>
> The most obvious would be to turn fsync off, sychronous_commit off,
> increase work_mem, increase checkpoint_timeout, increase wal_segments.
>
> JD
>
>>
>>
>>
>
can these be changed on the fly via set commands or does the config file have to be
changed and postgres stopped and restarted.

postgres 8.3.7 on freebsd.

-- 
Stephen Clark
NetWolves
Sr. Software Engineer III
Phone: 813-579-3200
Fax: 813-882-0209
Email: steve.clark@netwolves.com
www.netwolves.com