Josh Berkus <josh(at)agliodbs(dot)com> writes:
> Oh! Actually, it only *did* 27 runs. So it actually completed building
> the index. I'd expected trace_sort to give me some kind of completion
> message; apologies for not checking all screen windows.
Huh, there should be an "external sort ended" message, as well as some
other ones once it finishes writing the initial runs.
> So, why didn't the index build complete (after more than 36 hours) when
> I ran it as part of pg_restore? I guess this goes back to being a
> pg_restore problem and not an index build problem.
First thing that comes to mind is to wonder what maintenance_work_mem
setting was in effect for the pg_restore run.
regards, tom lane