| From: | Jie Liang <jie(at)stbernard(dot)com> |
|---|---|
| To: | Jie Liang <jie(at)stbernard(dot)com>, 'Bruce Momjian ' <pgman(at)candle(dot)pha(dot)pa(dot)us>, 'Tom Lane ' <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "'pgsql-admin(at)postgresql(dot)org '" <pgsql-admin(at)postgresql(dot)org>, "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | inefficiency of pg_restore |
| Date: | 2002-08-12 22:16:51 |
| Message-ID: | 7C760DAA511DC74B99E7D22189F786F101BF2163@mail01.stbernard.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
By default, pg_dump uses COPY to restore its data when we use
the plain text form, however, it's not the case when we use
the customer format, e.g.
pg_dump -Fc mydb > mydb.out
the documenation of pg_restore address
su-2.05$ time psql urldb<jurloldmail.out
You are now connected as new user jliang.
CREATE
real 0m0.662s
user 0m0.045s
sys 0m0.015s
su-2.05$ time pg_restore -cvt jurloldmail -d urldb urldb.out.020810
pg_restore: connecting to database for restore
pg_restore: dropping TABLE jurloldmail
pg_restore: connecting to database urldb as user jliang
pg_restore: creating TABLE jurloldmail
pg_restore: restoring data for table jurloldmail
real 0m6.880s
user 0m0.296s
sys 0m0.028s
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jie Liang | 2002-08-12 22:30:06 | ineffiency of pg_restore |
| Previous Message | Jie Liang | 2002-08-12 21:51:31 | Re: problem with select into and timestamp. |