Re: patch for parallel pg_dump

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: patch for parallel pg_dump
Дата
Msg-id 4F5F0C7302000025000461EA@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: patch for parallel pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: patch for parallel pg_dump
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> (I'm also unconvinced that sorting by relation size is a good idea
> anyway.  Anything that makes the dump order less predictable gets
> push-back, IME.)
Given that people often use diff on files from pg_dump,
unpredictable ordering can be a bad thing.  On the other hand, that
is not something you would probably want to do with the output of a
*parallel* dump, so if it only affect that, it probably makes sense.
It seems like a reasonable heuristic to avoid having all but some
big table done, and having to wait for that while the other
processors are sitting idle.
-Kevin


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

Предыдущее
От: Hans-Jürgen Schönig
Дата:
Сообщение: WIP: cross column correlation, 2nd shot
Следующее
От: Andres Freund
Дата:
Сообщение: Re: patch for parallel pg_dump