Horton
Menu

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

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Tomas Vondra <tv@fuzzy.cz>
Cc: pgsql-hackers@postgresql.org
Date: 2013-01-04T17:08:35Z
Lists: 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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Accelerate end-of-transaction dropping of relations