Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Дата
Msg-id 1512667895.2915.13.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade  (Gunther <raj@gusw.net>)
Ответы Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade  (Claudio Freire <klaussfreire@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
Gunther wrote:
> Something is wrong with the dump thing. And no, it's not SSL or whatever,
> I am doing it on a local system with local connections. Version 9.5 something.

That's a lot of useful information.

Try to profile where the time is spent, using "perf" or similar.

Do you connect via the network, TCP localhost or UNIX sockets?
The last option should be the fastest.

Yours,
Laurenz Albe

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade