Re: [PERFORM] Slow BLOBs restoring

2010-12-08 Thread Tom Lane
Vlad Arkhipov writes: > 08.12.2010 22:46, Tom Lane writes: >> 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. > No, I tried Linux only. OK, then it's not the missing-data-offsets issue. > I think you can reproduce it. First I cre

Re: [PERFORM] Slow BLOBs restoring

2010-12-08 Thread Vlad Arkhipov
08.12.2010 22:46, Tom Lane writes: 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. No, I tried Linux only. Not without a complete reproducible example ... and not at all if it's the known problem. The fix for that is to update pg

Re: [PERFORM] Slow BLOBs restoring

2010-12-08 Thread Vlad Arkhipov
08.12.2010 22:46, Tom Lane writes: 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. No, I tried Linux only. Not without a complete reproducible example ... and not at all if it's the known problem. The fix for that is to update

Re: [PERFORM] Slow BLOBs restoring

2010-12-08 Thread Tom Lane
Vlad Arkhipov 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

Re: [PERFORM] Slow BLOBs restoring

2010-12-08 Thread Vlad Arkhipov
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, ~

[PERFORM] Slow BLOBs restoring

2010-12-07 Thread Vlad Arkhipov
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 ite