"bharat u" <[EMAIL PROTECTED]> writes:
> Can anyone tell me how pg_analyze_and_rewrite works?
That's a rather broad question. Have you read the overview in the manual?
http://developer.postgresql.org/pgdocs/postgres/overview.html
pg_analyze_and_rewrite covers what that material calls the
"transformation process" and "query rewrite" stages of processing.
If you've got specific questions about pieces of that code,
pgsql-hackers is probably a better place than -general for asking 'em.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq