Re: Configuration Advice

[Benjamin Minshall <minshall(at)intellicon(dot)biz>]

> 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.

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

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature