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-08T21:30:25Z
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

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