On query rewrite

From: Sailesh Krishnamurthy <sailesh(at)cs(dot)berkeley(dot)edu>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: On query rewrite
Date: 2004-05-28 00:14:48
Message-ID: mjqn03twgp3.fsf@cs.berkeley.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2004-05-28 00:44:10 Re: On query rewrite
Previous Message John Hansen 2004-05-28 00:03:02 Re: How to get the Oid of the Primary key relation ??