On query rewrite - Mailing list pgsql-hackers

From Sailesh Krishnamurthy
Subject On query rewrite
Date
Msg-id mjqn03twgp3.fsf@cs.berkeley.edu
Whole thread Raw
Responses Re: On query rewrite  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
Hackers

Are there any default query rewrite rules that kick in, in the absence
of any user-defined RULE or VIEW ?

Also, is there any place that lists any "interesting" query rewrite
that PG does on queries for perf. improvement ? 

For instance, in the presence of a view or a subquery, does PG do a
subquery to join transformation ?

Thanks ! 

-- 
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh




pgsql-hackers by date:

Previous
From: John Hansen
Date:
Subject: Re: How to get the Oid of the Primary key relation ??
Next
From: Alvaro Herrera
Date:
Subject: Re: On query rewrite