Slow BLOBs restoring

From: Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)ru>
To: pgsql-performance(at)postgresql(dot)org
Subject: Slow BLOBs restoring
Date: 2010-12-07 08:36:59
Message-ID: 4CFDF22B.7060209@dc.baikal.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2010-12-07 08:42:22 Re: Hot Standby: too many KnownAssignedXids
Previous Message Koichi Suzuki 2010-12-07 08:23:19 Re: WIP patch for parallel pg_dump

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Polak 2010-12-07 17:34:25 Compared MS SQL 2000 to Postgresql 9.0 on Windows
Previous Message Greg Smith 2010-12-07 04:52:50 Re: Group commit and commit delay/siblings