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

Re: Configuration Advice

From: Steve <cheetah(at)tanabi(dot)org>
To: Benjamin Minshall <minshall(at)intellicon(dot)biz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Configuration Advice
Date: 2007-01-17 21:58:05
Message-ID: Pine.GSO.4.64.0701171656450.4471@kingcheetah.tanabi.org (view raw or flat)
Thread:
Lists: pgsql-performance

On Wed, 17 Jan 2007, Benjamin Minshall wrote:

>
>> Building these indexes takes forever!
>
>> Anyway -- ANYTHING we can do to make this go faster is appreciated :) 
>> Here's some vital statistics:
>
>> - Machine is a 16 GB, 4 actual CPU dual-core opteron system using SCSI 
>> discs.  The disc configuration seems to be a good one, it's the best of all 
>> the ones we've tested so far.
>
> What are your shared_buffers, work_mem, and maintenance_work_mem settings?
>
> maintenance_work_mem is used for CREATE INDEX, and with 16GB of memory in the 
> machine, maintenance_work_mem should be set to at least 1GB in my opinion.
>

shared_buffers = 8GB
work_mem = 256MB
maintenance_work_mem = 6GB

So that should be covered, unless I'm using too much memory and swapping. 
It does look like it's swapping a little, but not too badly as far as I 
can tell.  I'm thinking of dialing back everything a bit, but I'm not 
really sure what the heck to do :)  It's all guessing for me right now.


Steve

In response to

Responses

pgsql-performance by date

Next:From: Bruno Wolff IIIDate: 2007-01-17 22:12:29
Subject: Re: Configuration Advice
Previous:From: SteveDate: 2007-01-17 21:56:30
Subject: Re: Configuration Advice

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