>TL> It's a good idea to bump up sort_mem as high as you can before running
>TL> the restore, so that the index builds run as fast as possible. Assuming
>
>Wouldn't it make a cool option to pg_restore to be able to set
>sort_mem for the current connection?
>
>
>
I was thinking the very same thing. If it is a must to always bump up
sort_mem before running restore why can't the restore utility do it?
Take a portion of the currently available memory or ask a user
interactively etc.
Kaarel