Re: Make executor's Range Table an array instead of a List

2018-09-04 Thread Amit Langote
On 2018/09/04 17:14, David Rowley wrote: > On 4 September 2018 at 19:31, Amit Langote > wrote: >> On 2018/08/24 7:22, David Rowley wrote: >>> On 24 August 2018 at 02:26, Amit Langote wrote: One of the patches I sent last week does the same thing, among a couple of other things with

Re: Make executor's Range Table an array instead of a List

2018-09-04 Thread David Rowley
On 4 September 2018 at 19:31, Amit Langote wrote: > On 2018/08/24 7:22, David Rowley wrote: >> On 24 August 2018 at 02:26, Amit Langote wrote: >>> One of the patches I sent last week does the same thing, among a >>> couple of other things with regard to handling relations in the >>> executor.

Re: Make executor's Range Table an array instead of a List

2018-09-04 Thread Amit Langote
On 2018/08/24 7:22, David Rowley wrote: > On 24 August 2018 at 02:26, Amit Langote wrote: >> One of the patches I sent last week does the same thing, among a >> couple of other things with regard to handling relations in the >> executor. On a cursory look at the patch, your take of it looks >>

Re: Make executor's Range Table an array instead of a List

2018-08-23 Thread David Rowley
On 24 August 2018 at 02:26, Amit Langote wrote: > One of the patches I sent last week does the same thing, among a > couple of other things with regard to handling relations in the > executor. On a cursory look at the patch, your take of it looks > better than mine. Will test tomorrow. Here is

Re: Make executor's Range Table an array instead of a List

2018-08-23 Thread Amit Langote
(sorry David for the same email twice, I didn't hit Reply All at first) On Thu, Aug 23, 2018 at 7:58 PM, David Rowley wrote: > Continuing along on my adventures of making performance improvements > for partitioned tables, I discovered that getrelid is quite slow in > InitPlan() during UPDATEs

Make executor's Range Table an array instead of a List

2018-08-23 Thread David Rowley
Continuing along on my adventures of making performance improvements for partitioned tables, I discovered that getrelid is quite slow in InitPlan() during UPDATEs and DELETEs when there are many resultRelations to process. A List is a pretty poor choice for this data structure since we already