Re: algebraic rewriting - Mailing list pgsql-novice

From Tom Lane
Subject Re: algebraic rewriting
Date
Msg-id 1968.1019239478@sss.pgh.pa.us
Whole thread Raw
In response to algebraic rewriting  (sophie yang <yangsophie@yahoo.com>)
Responses Re: algebraic rewriting  (sophie yang <yangsophie@yahoo.com>)
List pgsql-novice
sophie yang <yangsophie@yahoo.com> writes:
> rewriter, optimizer and executor. I am wondering at
> which step, PostgreSQL performs algebraic rewriting?

What do you consider "algebraic rewriting"?  The optimizer does a pass of
constant-subexpression simplification, and also some boolean-expression
normalization, but I'm not sure if that's what you're looking for.

            regards, tom lane

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: plpgsql
Next
From: Ugly Hippo
Date:
Subject: Re: SQL profiler feature in Pgsql?