Re: Horribly slow pg_upgrade performance with many Large Objects

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: Horribly slow pg_upgrade performance with many Large Objects
Дата
Msg-id CAMT0RQRT3KkwoQkx=YBdd_o9SqXxOt16fqQsscH_n+40Z57N7w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Horribly slow pg_upgrade performance with many Large Objects  (Nathan Bossart <nathandbossart@gmail.com>)
Ответы Re: Horribly slow pg_upgrade performance with many Large Objects
Список pgsql-hackers
Ah, I see.

I retried and now it runs for 21 to 29 seconds for 1 million large
objects with two grants each, 3M total rows inserted.

Yesterday it ran 8 seconds. Unfortunately I do not have the plan from
yesterday saved .

Anyway it looks like just dumping pg_shdepend it is better, and likely
also compresses very well for most users

--
Hannu



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