Kenneth Tilton <kentilton@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
