ineffiency of pg_restore

Поиск
Список
Период
Сортировка
Искать
От
Jie Liang
Тема
ineffiency of pg_restore
Дата
Msg-id
7C760DAA511DC74B99E7D22189F786F101BF2164@mail01.stbernard.com
Список
Дерево обсуждения
Re: ineffiency of pg_restore Jie Liang <jie@stbernard.com>
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.
I believe that if we can have following feature:
1. quick restore(use COPY not INSERTs),
2. restore related objects, e.g. when we restore a table, we can choose
   to restore its indexes, triggers and related sequence etc.

that will be great, I expect that we have them in next version of release.


test log:

su-2.05$ time psql urldb
В списке pgsql-admin по дате отправления
От: Jie Liang
Дата:
Сообщение: inefficiency of pg_restore
От: Tom Lane
Дата:
Сообщение: Re: ineffiency of pg_restore
FAQ