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.
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.
Sr. Software Engineer III
In response to
pgsql-general by date
|Next:||From: Joshua Berry||Date: 2010-08-25 17:29:06|
|Subject: Re: Optimizing queries that use multiple tables and many
order by columns|
|Previous:||From: Joshua D. Drake||Date: 2010-08-25 16:30:57|
|Subject: Re: Feature proposal|