Re: Slow BLOBs restoring

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Slow BLOBs restoring
Дата
Msg-id 14439.1291819581@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Slow BLOBs restoring  (Vlad Arkhipov <arhipov@dc.baikal.ru>)
Ответы Re: Slow BLOBs restoring
Re: Slow BLOBs restoring
Список pgsql-performance
Vlad Arkhipov <arhipov@dc.baikal.ru> writes:
> I discovered this issue a bit more. -j option is slowing down BLOBs
> restoring. It's about 1000x times slower if you specify this option.

Are you by any chance restoring from an 8.3 or older pg_dump file made
on Windows?  If so, it's a known issue.

> Does anybody plan to fix it?

Not without a complete reproducible example ... and not at all if it's
the known problem.  The fix for that is to update pg_dump to 8.4 or
later.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Performance under contention
Следующее
От: Bryce Nesbitt
Дата:
Сообщение: hashed subplan 5000x slower than two sequential operations