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:
2012-08-24 22:36:34 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2012-08-30 15:53:00 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-08-30 19:17:46 from "Tomas Vondra" <tv(at)fuzzy(dot)cz>
2012-08-30 21:48:23 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-10-17 10:34:24 from Shigeru HANADA <shigeru(dot)hanada(at)gmail(dot)com>
2012-10-17 11:45:01 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2012-10-18 02:28:32 from 花田 茂 <shigeru(dot)hanada(at)gmail(dot)com>
2012-10-18 15:58:53 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-11-11 19:36:46 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2012-12-06 04:47:22 from Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com>
2012-12-06 22:38:59 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2012-12-08 14:26:08 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-08 14:49:17 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2012-12-08 16:07:38 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2012-12-10 05:27:40 from Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com>
2012-12-10 15:38:01 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-10 17:24:27 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2012-12-16 23:31:00 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2012-12-19 01:18:14 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-20 01:54:48 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2012-12-20 11:33:00 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-24 01:41:37 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2012-12-30 03:03:42 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-12-31 16:51:41 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2013-01-01 16:35:39 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-01 16:43:53 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2013-01-04 16:42:07 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-06 03:35:30 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2013-01-07 09:07:39 from Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com>
2013-01-07 22:08:31 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2013-01-08 02:47:34 from Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com>
2013-01-08 20:56:41 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2013-01-08 21:30:25 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-08 21:38:52 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2013-01-09 07:03:44 from Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com>
2013-01-04 17:08:35 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-17 19:19:38 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-17 19:39:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-17 23:55:05 from Tomas Vondra <tv(at)fuzzy(dot)cz>
2013-01-18 01:30:11 from Craig Ringer <craig(at)2ndQuadrant(dot)com>
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:23Subject : Re: json api WIP patchPrevious :From : Peter EisentrautDate : 2013-01-08 21:25:37Subject : Re: PL/Python result object str handler
