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
Drugs may lead to nowhere, but at least it's the scenic route.
In response to
pgsql-performance by date
|Next:||From: Douglas J Hunley||Date: 2008-02-20 13:28:17|
|Subject: Re: 7 hrs for a pg_restore?|
|Previous:||From: Richard Huxton||Date: 2008-02-20 11:38:09|
|Subject: Re: Need Help selecting Large Data From PQSQL|