Re: PATCH: optimized DROP of multiple tables within a transaction

<div class="moz-cite-prefix">On 01/18/2013 03:19 AM, Alvaro Herrera wrote:<br /></div><blockquote
cite="mid:20130117191938.GA4033@alvh.no-ip.org"type="cite"><pre wrap="">Tomas Vondra wrote:
 
</pre><blockquote type="cite"><pre wrap="">Hi,

attached is a patch that improves performance when dropping multiple
tables within a transaction. Instead of scanning the shared buffers for
each table separately, the patch removes this and evicts all the tables
in a single pass through shared buffers.
</pre></blockquote><pre wrap="">
Made some tweaks and pushed (added comments to new functions, ensure
that we never try to palloc(0), renamed DropRelFileNodeAllBuffers to
plural, made the "use bsearch" logic a bit simpler).</pre></blockquote> Commit ref is <br /><br /><a
href="http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=279628a0a7cf582f7dfb68e25b7b76183dd8ff2f">http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=279628a0a7cf582f7dfb68e25b7b76183dd8ff2f</a><br
/><br/> Flagged as committed.<br /><br /><pre class="moz-signature" cols="72">-- Craig Ringer                   <a
class="moz-txt-link-freetext"href="http://www.2ndQuadrant.com/">http://www.2ndQuadrant.com/</a>PostgreSQL Development,
24x7Support, Training & Services</pre>