Jeff Davis <pgsql@j-davis.com> 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