Re: ineffiency of pg_restore

I use:
pg_dump -Fc -d urldb > urldb.out.020810
I can make another test and get the log

Jie Liang

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Monday, August 12, 2002 3:38 PM
To: Jie Liang
Cc: 'Bruce Momjian '; 'pgsql-admin(at)postgresql(dot)org ';
'pgsql-bugs(at)postgresql(dot)org'
Subject: Re: [ADMIN] ineffiency of pg_restore

Jie Liang <jie(at)stbernard(dot)com> writes:
> pg_restore give admin a lot of flexabilities, it can restore any object
> from a single dump file. But if the table is very big, e.g. 2M records,
> it will take a long time to restore because it use INSERTs.

This is demonstrably not the case --- at least not by default. You
get the same commands you would've gotten from pg_dump. Sure you
didn't create the dump file with "-d" ?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org