Re: Query kills machine.

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Stef <svb(at)ucs(dot)co(dot)za>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query kills machine.
Date: 2004-08-24 09:08:50
Message-ID: 412B05A2.8070301@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

For starters,

> ------------------------------------------------------------------------
>
> shared_buffers = 110592
> wal_buffers = 400
> sort_mem = 30720
> vacuum_mem = 10240
> checkpoint_segments = 30
> commit_delay = 5000
> commit_siblings = 100
> effective_cache_size = 201413

Try more like this:

shared_buffers = 30000
wal_buffers = <default>
sort_mem = 4096
vacuum_mem = 10240
checkpoint_segments = 30
commit_delay = <default>
commit_siblings = <default>
effective_cache_size = 100000

Chris

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jan Wieck 2004-08-24 12:00:39 Re: postgresql performance with multimedia
Previous Message Stef 2004-08-24 08:32:40 Query kills machine.