Re: Multicolun index creation never completes on 9.0.1/solaris

Josh Berkus <josh@agliodbs.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