| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua Berry | 2010-08-25 17:29:06 | Re: Optimizing queries that use multiple tables and many order by columns |
| Previous Message | Joshua D. Drake | 2010-08-25 16:30:57 | Re: Feature proposal |