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