On Dec 27, 2012, at 12:46 PM, Tom Lane wrote:
> Or you could run contrib/pgstattuple's pgstattuple() function every so
> often --- it will report the uncommitted tuples as "dead", which is
> inaccurate, but you'd be able to see how fast the number is increasing.
That's exactly the kind of thing I
Scott Ribe writes:
> Is there any way to get some insight into the progress of:
> insert into foo select distinct on (...) from bar where...
Watching the physical size of the foo table might be close enough.
Or you could run contrib/pgstattuple's pgstattuple() function every so
often --- it will
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
