Re: Nooby Q: Should this take five hours? And counting?

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