Re: Inheritance planner CPU and memory usage change since 9.3.2 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Inheritance planner CPU and memory usage change since 9.3.2
Date
Msg-id 593.1434904159@sss.pgh.pa.us
Whole thread Raw
In response to Re: Inheritance planner CPU and memory usage change since 9.3.2  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-hackers
Dean Rasheed <dean.a.rasheed@gmail.com> writes:
> However, there's an obvious improvement that can be made to Tom's
> patch -- having computed modifiableARIindexes, you may as well use it
> in the innermost loop to only apply ChangeVarNodes() to those
> AppendRelInfo's that can actually change, rather than having it trawl
> through all the other ones that we know won't be touched.

Right.  Also, as Robert noted, we can short-circuit a few more things when
there are no subquery RTEs.  I'll combine these ideas and push something,
but probably not till tomorrow.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pg_stat_*_columns?
Next
From: Andres Freund
Date:
Subject: Backpatch src/test/modules to 9.3?