| From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
|---|---|
| To: | "Douglas J Hunley" <doug(at)hunley(dot)homeip(dot)net> |
| Cc: | "Erik Jones" <erik(at)myemma(dot)com>, "Jeff" <threshar(at)threshar(dot)is-a-geek(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Richard Huxton" <dev(at)archonet(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: 7 hrs for a pg_restore? |
| Date: | 2008-02-20 14:14:13 |
| Message-ID: | 874pc3ww96.fsf@oxford.xeocode.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"Douglas J Hunley" <doug(at)hunley(dot)homeip(dot)net> writes:
> 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
I would suggest leaving out the && which only obfuscate what's going on here.
PGOPTIONS=... pg_restore ...
would work just as well and be clearer about what's going on.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's Slony Replication support!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Stone | 2008-02-20 15:31:13 | Re: Anyone using a SAN? |
| Previous Message | C. Bergström | 2008-02-20 13:52:42 | Re: Anyone using a SAN? |