As a follow up to my own question:
I reran the COPY both ways (with the index
and without) while running iostat. The following values
are averages:
%user %nice %sys %iowait %idle
no index
39 0
2.8 11 47
index
16 1.5 2.1
34 46
Im no performance guru, so please
indulge a couple of
I only have one CPU. Is my copy of iostat confused, or does this have
something to do with hyperthreading or dual core? (AFAIK, I don't have a
dual core!)
The problem (for me) with dropping the index during a copy is that it takes
tens of minutes (or more) to recreate the geometry index once