Skip site navigation (1) Skip section navigation (2)

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

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Tomas Vondra <tv(at)fuzzy(dot)cz>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PATCH: optimized DROP of multiple tables within a transaction
Date: 2013-01-08 21:30:25
Message-ID: 20130108213025.GD9218@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-hackers
Tomas Vondra wrote:
> On 8.1.2013 03:47, Shigeru Hanada wrote:

> >>> * +1 for Alvaro's suggestion about avoiding palloc traffic by starting
> >>> with 8 elements or so.
> >>
> >> Done.
> > 
> > Not yet.  Initial size of srels array is still 1 element.
> 
> I've checked the patch and I see there 'maxrels = 8' - or do you mean
> something else?

Well, you need to ensure that the initial palloc is an array of that
size.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


In response to

Responses

pgsql-hackers by date

Next:From: jamesDate: 2013-01-08 21:31:23
Subject: Re: json api WIP patch
Previous:From: Peter EisentrautDate: 2013-01-08 21:25:37
Subject: Re: PL/Python result object str handler

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group