Horton

Re: 7 hrs for a pg_restore?

Dave Cramer <pg@fastcrypt.com>

View thread
From: Dave Cramer <pg@fastcrypt.com>
To: Douglas J Hunley <doug@hunley.homeip.net>
Cc: "Joshua D. Drake" <jd@commandprompt.com>, pgsql-performance@postgresql.org
Date: 2008-02-19T19:28:54Z
Lists: pgsql-performance 
shared buffers is *way* too small as is effective cache
set them to 2G/6G respectively.

Dave