Re: 7 hrs for a pg_restore?
Doug Hunley <doug@hunley.homeip.net>
From: Douglas J Hunley <doug@hunley.homeip.net>
To: Erik Jones <erik@myemma.com>
Cc: Jeff <threshar@threshar.is-a-geek.com>, Tom Lane <tgl@sss.pgh.pa.us>, Richard Huxton <dev@archonet.com>, pgsql-performance@postgresql.org
Date: 2008-02-20T13:26:38Z
Lists: pgsql-performance
On Tuesday 19 February 2008 16:32:02 Erik Jones wrote: > pg_restore is a postgres client app that uses libpq to connect and, > thus, will pick up anything in your $PGOPTIONS env variable. So, > > PGOPTONS="-c maintenance_work_mem=512MB" && pg_restore .... now that's just plain cool /me updates our wiki -- Douglas J Hunley (doug at hunley.homeip.net) - Linux User #174778 http://doug.hunley.homeip.net Drugs may lead to nowhere, but at least it's the scenic route.