Jeff Davis <pgsql@xxxxxxxxxxx> writes:
> On Mon, 2007-09-10 at 17:06 -0700, Jason L. Buberel wrote:
>> However, I now have tables so large that even the 'recreate all
>> indices' step is taking too long (15-20 minutes on 8.2.4).
> If you create the indexes with CONCURRENTLY, then you can write to the
> tables while the indexes are being created. That might help reduce your
> downtime window.
Also, I trust you've experimented to find the optimal
maintenance_work_mem for this task on your machine? It's probably
more on 8.2.x than it was before, since we improved the sort code...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
