Re: pg_dump order of operation

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: pg_dump order of operation
Дата
Msg-id
19812.1535297050@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
pg_dump order of operation Ron <ronljohnsonjr@gmail.com>
Re: pg_dump order of operation Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump order of operation Ron <ronljohnsonjr@gmail.com>
Re: pg_dump order of operation Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump order of operation Ron <ronljohnsonjr@gmail.com>
Re: pg_dump order of operation Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump order of operation Ron <ronljohnsonjr@gmail.com>
Ron  writes:
> In v8.4, I noticed that the tables seemed to be dumped in alphabetical 
> order.  Not so much, though, in a multithreaded 9.6 dump of an 8.4 database; 
> there's no pattern that I can discern.
> In what order does the 9.6 pg_dump dump tables?

I don't believe the ordering rules have changed materially since 8.4;
it's intended to be by object kind, and within that by name, except
where dependencies force doing something else.

But what are you thinking constitutes the "dump order" in a parallel dump?

			regards, tom lane

В списке pgsql-general по дате отправления
От: Raghavendra Rao J S V
Дата:
От: Wilhansen Li
Дата:
FAQ