Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group