Re: Query kills machine. - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: Query kills machine.
Date
Msg-id 412B05A2.8070301@familyhealth.com.au
Whole thread Raw
In response to Query kills machine.  (Stef <svb@ucs.co.za>)
Responses Re: Query kills machine.  (Stef <svb@ucs.co.za>)
List 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


pgsql-performance by date:

Previous
From: Stef
Date:
Subject: Query kills machine.
Next
From: Jan Wieck
Date:
Subject: Re: postgresql performance with multimedia