Skip site navigation (1) Skip section navigation (2)

Re: Feature proposal

From: Steve Clark <sclark(at)netwolves(dot)com>
To: jd(at)commandprompt(dot)com, pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Feature proposal
Date: 2010-08-25 17:06:46
Message-ID: 4C754DA6.9040103@netwolves.com (view raw or flat)
Thread:
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(dot)clark(at)netwolves(dot)com
www.netwolves.com

In response to

Responses

pgsql-general by date

Next:From: Joshua BerryDate: 2010-08-25 17:29:06
Subject: Re: Optimizing queries that use multiple tables and many order by columns
Previous:From: Joshua D. DrakeDate: 2010-08-25 16:30:57
Subject: Re: Feature proposal

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group