>>>>> "TL" == Tom Lane <tgl@sss.pgh.pa.us> writes:
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?
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/