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: (view raw, whole thread or download thread mbox)
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
Sr. Software Engineer III
Phone: 813-579-3200
Fax: 813-882-0209
Email: steve(dot)clark(at)netwolves(dot)com

In response to


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-2017 The PostgreSQL Global Development Group