On Sat, Apr 18, 2009 at 4:11 PM, Kenneth Tilton <kentilton@xxxxxxxxx> wrote: > ie, 5hrs and counting, no clue how long it intends to run, but methinks this > is insane even if it is 10^7 records, mebbe half a dozen dups per value (a > product-id usually around 8-chars long): > > CREATE INDEX web_source_items_by_item_id_strip > ON web_source_items > USING btree (item_id_strip); > > Am I unreasonably impatient? > > I see pg getting just a few % CPU on a heavily ram/core-endowed Sun box with > nothing else going on. Mebbe they installed pg on a compact flash? DVD-RW? > /usr/local/something, prolly not. What does vmstat 1 60 say during the index build? Specifically the cpu columns for user, system, wa? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
