When I use pg_dump to back up the whole database and then pg_restore an
pg_restore uses COPY. Great.
When I use pg_dump to back up an individual table and pg_restore it,
pg_restore uses INSERT.
pg_dump mydb -R -Fc --compress=9 > method1.dmp
pg_restore -t mytable -d mydb -R method1.dmp
I will see COPY in both OS and SQL.
pg_dump mydb -t mytable -R -Fc --compress=9 > method2.dmp
pg_restore -d mydb -R method2.dmp
I will see INSERT in both OS and SQL.
Is this an expected behavior?
This is a big table with million rows in a big database. How can I speed
up individual table back and restore
if this assessment is true?
My PG version is 7.3.2 (I know, I know, it'd old...)
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2005-03-24 15:52:06|
|Subject: Re: pg_dump, pg_restore, insert vs copy |
|Previous:||From: Tom Lane||Date: 2005-03-24 14:49:16|
|Subject: Re: Why this Query Plan is different |