Re: [PERFORM] Slow BLOBs restoring - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: [PERFORM] Slow BLOBs restoring
Date
Msg-id 4D00FD65.1020501@dunslane.net
Whole thread Raw
In response to Re: [PERFORM] Slow BLOBs restoring  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

On 12/09/2010 10:05 AM, Tom Lane wrote:
> I think what we need to do is make fix_dependencies
> build a reverse lookup list of all the objects dependent on each TOC
> object, so that the searching behavior in reduce_dependencies can be
> eliminated outright.  That will take O(N) time and O(N) extra space,
> which is a good tradeoff because you won't care if N is small, while if
> N is large you have got to have it anyway.
>
> Barring objections, I will do this and back-patch into 9.0.  There is
> maybe some case for trying to fix 8.4 as well, but since 8.4 didn't
> make a separate TOC entry for each blob, it isn't as exposed to the
> problem.  We didn't back-patch the last round of efficiency hacks in
> this area, so I'm thinking it's not necessary here either.  Comments?
>
>             


Sound good. Re 8.4: at a pinch people could probably use the 9.0 
pg_restore with their 8.4 dump.

cheers

andrew


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [PERFORM] Slow BLOBs restoring
Next
From: Dimitri Fontaine
Date:
Subject: Re: Solving sudoku using SQL