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

Re: Configuration Advice

From: Benjamin Minshall <minshall(at)intellicon(dot)biz>
To: Steve <cheetah(at)tanabi(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Configuration Advice
Date: 2007-01-17 21:33:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
> 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 

Benjamin Minshall <minshall(at)intellicon(dot)biz>
Senior Developer -- Intellicon, Inc.

In response to


pgsql-performance by date

Next:From: Chad WagnerDate: 2007-01-17 21:34:10
Subject: Re: Configuration Advice
Previous:From: Tomas VondraDate: 2007-01-17 21:32:25
Subject: Re: Configuration Advice

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