Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow restoration question - Mailing list pgsql-performance

From Tom Lane
Subject Re: Slow restoration question
Date
Msg-id 6110.1146342203@sss.pgh.pa.us
Whole thread Raw
In response to Slow restoration question  (Eric Lam <elam@lisasoft.com>)
Responses Re: Slow restoration question
Re: Slow restoration question
List pgsql-performance
Tree view 
Eric Lam <elam@lisasoft.com> writes:
> what is the quickest way of dumping a DB and restoring it? I have done a

>    "pg_dump -D database | split --line-bytes 1546m part"

Don't use "-D" if you want fast restore ...

            regards, tom lane

pgsql-performance by date:

Previous
From: "Gregory Stewart"
Date:
Subject: Performance Issues on Opteron Dual Core
Next
From: Andreas Kretschmer
Date:
Subject: Re: Slow restoration question