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 по дате отправления