| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)ru> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Slow BLOBs restoring |
| Date: | 2010-12-08 14:46:21 |
| Message-ID: | 14439.1291819581@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2010-12-08 14:48:52 | Re: serializable read only deferrable |
| Previous Message | Andrew Dunstan | 2010-12-08 14:45:09 | Re: pg_type.typname of array types. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | salima | 2010-12-08 16:53:21 | Tunning Postgres |
| Previous Message | Tom Lane | 2010-12-08 14:34:23 | Re: Performance under contention |