Re: pg_dump additional options for performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump additional options for performance
Дата
Msg-id 4106.1204595787@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump additional options for performance  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: pg_dump additional options for performance  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Added to TODO based on this discussion:

>         o To better utilize resources, restore data, primary keys, and
>           indexes for a single table before restoring the next table

That idea seems quite misguided, and certainly was not anywhere in the
prior discussion.  If you add an ordering constraint as strong as that,
you'll mostly just eliminate chances for parallelism.  Also, the
following para describes something completely different:

>           Hopefully this will allow the CPU-I/O load to be more uniform
>           for simultaneous restores.  The idea is to start data restores
>           for several objects, and once the first object is done, to move
>           on to its primary keys and indexes.  Over time, simultaneous
>           data loads and index builds will be running.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: 8.3 / 8.2.6 restore comparison
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_dump additional options for performance