Re: Further pg_upgrade analysis for many tables

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Further pg_upgrade analysis for many tables
Дата
Msg-id CAMkU=1yP3x3ZZNMfYVOzxVEszM3OhVVASpGnXsEkU4=ODSzW3Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Further pg_upgrade analysis for many tables  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Further pg_upgrade analysis for many tables  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Дерево обсуждения 
On Thu, Nov 8, 2012 at 7:25 PM, Bruce Momjian <bruce@momjian.us> wrote:
>
> I did some more research and realized that I was not using --schema-only
> like pg_upgrade uses.  With that setting, things look like this:
>
...

For profiling pg_dump in isolation, you should also specify
--binary-upgrade.  I was surprised that it makes a big difference,
slowing it down by about 2 fold.

Cheers,

Jeff

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

Предыдущее
От: Daniel Farina
Дата:
Сообщение: Re: Inadequate thought about buffer locking during hot standby replay
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Inadequate thought about buffer locking during hot standby replay