On Thu, Mar 17, 2011 at 7:25 AM, Michael Andreasen mich...@dunlops.com wrote:
Currently I am using a twin processor box with 2GB of memory and raid 5
disk.
I start postgres before my load with these settings, which have been
suggested.
I restore like this;
pg_restore -Fc -j 4 -i -O -d my_db
Andy Colson a...@squeakycode.net wrote:
On 03/17/2011 09:25 AM, Michael Andreasen wrote:
I've been looking around for information on doing a pg_restore as
fast as possible.
I am using a twin processor box with 2GB of memory
shared_buffers = 496MB
Probably about right.
On 3/18/2011 9:38 AM, Kevin Grittner wrote:
Andy Colsona...@squeakycode.net wrote:
On 03/17/2011 09:25 AM, Michael Andreasen wrote:
I've been looking around for information on doing a pg_restore as
fast as possible.
bgwriter_lru_maxpages = 0
I hadn't thought much about that last one --
Hi,
I've been looking around for information on doing a pg_restore as fast as
possible. It is for a backup machine so I am not interested in anything like
crash recovery or anything else that would impact speed of load. I just want
to go from no database to database there as fast as possible. The
On 03/17/2011 09:25 AM, Michael Andreasen wrote:
Hi,
I've been looking around for information on doing a pg_restore as fast as
possible. It is for a backup machine so I am not interested in anything like
crash recovery or anything else that would impact speed of load. I just want to
go from