Re: making update/delete of inheritance trees scale better

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Amit Langote <amitlangote09(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: making update/delete of inheritance trees scale better
Date: 2021-03-30 18:50:23
Message-ID: 2919852.1617130223@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wrote:
> ... I also tried variants
> of that involving updating two columns of a 6-column table and of a
> 10-column table, figuring that those cases might be a bit more
> representative of typical usage (see attached scripts).

Argh, I managed to attach the wrong file for the 10-column test
case. For the archives' sake, here's the right one.

regards, tom lane

Attachment Content-Type Size
heikki10.sql text/plain 341 bytes

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message igor levshin 2021-03-30 18:51:26 Re: Failed assertion on standby while shutdown
Previous Message Tom Lane 2021-03-30 18:39:18 Re: making update/delete of inheritance trees scale better