pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andrew Dunstan <andrew@dunslane.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: [PERFORM] Slow BLOBs restoring
Date: Thu, 09 Dec 2010 11:01:41 -0500
Message-ID: <4D00FD65.1020501@dunslane.net> (raw)
In-Reply-To: <6530.1291907115@sss.pgh.pa.us>
References: <4CFDF22B.7060209@dc.baikal.ru>
	<4CFF46BD.8070004@dc.baikal.ru>
	<14439.1291819581@sss.pgh.pa.us>
	<4D00559C.6070009@dc.baikal.ru>
	<29435.1291872532@sss.pgh.pa.us>
	<6530.1291907115@sss.pgh.pa.us>



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



view thread (11+ messages)

Message-ID: <4D00FD65.1020501@dunslane.net>
Permalink:  ../4D00FD65.1020501@dunslane.net/
Also on:    postgresql.org/message-id/4D00FD65.1020501@dunslane.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: andrew@dunslane.net, tgl@sss.pgh.pa.us, pgsql-hackers@postgreSQL.org
  Subject: Re: [PERFORM] Slow BLOBs restoring
  In-Reply-To: <4D00FD65.1020501@dunslane.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox