Kenneth Tilton <kentilton@gmail.com> writes:
> A bit. I killed the indexing and jacked work_mem up to 500mb, indexing then
> finished in 7 min 25s.
>
> Yer a genius!
FWIW creating indexes using maintenance_work_mem. I would not expect changing
work_mem to really help much. That's, uh, curious.
>> 2: You've got a slow disk subsystem, if you're already seeing 25%
>> IOWait with only ~2 to 3 megs a second being written.
>
> This has been passed along to management for consideration.
Depends. If it's all random i/o then 8-12MB/s is about right for 4-6 drives.
If there's any sequential i/o mixed in then yeah, it's pretty poor.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's On-Demand Production Tuning
