On Fri, Mar 11, 2005 at 05:29:11PM -0500, Arshavir Grigorian wrote:
> Tom Lane wrote:

> >The defaults are made for a fairly small machine, not big iron.  At a
> >minimum you want to kick shared_buffers up to 10K or more.
> >
> Will do. Thanks.

Also, it may help that you bump up sort_mem while doing [the CREATE
INDEX part of] the restore.

-- 
Alvaro Herrera (<[EMAIL PROTECTED]>)
"We are who we choose to be", sang the goldfinch
when the sun is high (Sandman)

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to