Yuji Shinozaki <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
