Re: PATCH: optimized DROP of multiple tables within a transaction - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: PATCH: optimized DROP of multiple tables within a transaction
Date
Msg-id 20130104170835.GA9191@alvh.no-ip.org
Whole thread Raw
In response to Re: PATCH: optimized DROP of multiple tables within a transaction  (Tomas Vondra <tv@fuzzy.cz>)
List pgsql-hackers
On Mon, Dec 24, 2012 at 02:41:37AM +0100, Tomas Vondra wrote:

> +    SMgrRelation   *srels = palloc(sizeof(SMgrRelation));
> +    int            nrels = 0,
> +                i = 0,
> +                maxrels = 1;

maxrels=1 is not good -- too much palloc traffic.  I'd make it start at,
say, 8 instead.

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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: lock AccessShareLock on object 0/1260/0 is already held
Next
From: Robert Haas
Date:
Subject: Re: enhanced error fields