Re: Slow BLOBs restoring - Mailing list pgsql-performance

From Tom Lane
Subject Re: Slow BLOBs restoring
Date
Msg-id 14439.1291819581@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slow BLOBs restoring  (Vlad Arkhipov <arhipov@dc.baikal.ru>)
Responses Re: Slow BLOBs restoring
Re: Slow BLOBs restoring
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance under contention
Next
From: Bryce Nesbitt
Date:
Subject: hashed subplan 5000x slower than two sequential operations