Re: Slow BLOBs restoring
| От | Vlad Arkhipov |
|---|---|
| Тема | Re: Slow BLOBs restoring |
| Дата | |
| Msg-id | 4CFF46BD.8070004@dc.baikal.ru обсуждение исходный текст |
| Ответ на | Slow BLOBs restoring (Vlad Arkhipov <arhipov@dc.baikal.ru>) |
| Ответы |
Re: Slow BLOBs restoring
|
| Список | pgsql-performance |
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. Does anybody plan to fix it? > I have encountered a problem while restoring the database. There is a > table that contains XML data (BLOB), ~ 3 000 000 records, ~ 5.5Gb of > data. pg_restore has been running for a week without any considerable > progress. There are plenty of lines like these in the log: > > pg_restore: processing item 3125397 BLOB 10001967 > pg_restore: executing BLOB 10001967 > > CPU usage is 100% always. The total database size is about 100 Gb and > it restores in an hour or so without BLOBs. >
В списке pgsql-performance по дате отправления: