> 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