Is there any way to get some insight into the progress of:

insert into foo select distinct on (...) from bar where...

It's got to with importing some legacy data, which has no proper primary key, 
and duplicates, and garbage that won't be accepted. And there's 30,000,000 
rows, and I'm running on a slow disk for testing--so I know this is going to be 
painfully slow. But after a few hours I'd like to know if it's going to finish 
overnight, or if it will take so long that I need to look at alternate 
approaches.

(I upped my shared buffers & work mem, so explain on the select statement shows 
a bit better than 50% reduction in predicted work for that part. And I will go 
ahead and drop all indexes on the target table.)

-- 
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice






-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to