Yuji Shinozaki <ys2n(at)virginia(dot)edu> writes:
> Then the problem is that
> reindexing takes a very long time. One particular index is taking on the
> order of 12 hours to finish.
Seems like a lot. What is the index definition exactly, and how many
rows in the table? If it's a btree, have you tried increasing sort_mem
in the restore session?
regards, tom lane