Re: Nooby Q: Should this take five hours? And counting? - Mailing list pgsql-general

From Gregory Stark
Subject Re: Nooby Q: Should this take five hours? And counting?
Date
Msg-id 87k55fwr7q.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Nooby Q: Should this take five hours? And counting?  (Kenneth Tilton <kentilton@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Gregory Stark
Date:
Subject: Re: DISTINCT ON without ORDER BY
Next
From: Alban Hertroys
Date:
Subject: Re: Frequently unable connecting to db "server doesn't listen"