[GENERAL] hard parse? - Mailing list pgsql-general

From Peter Koukoulis
Subject [GENERAL] hard parse?
Date
Msg-id CABpxA9hOgg+btm15NoJ_GTSpt0Uwm9TxA1ZV0bPmtvHSUJSU5Q@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] hard parse?
List pgsql-general
Hi

I have a query where a filter would always be negative, how many steps, out these:
  • parsing and syntax check
  • semantic analysis
  • transformation process (query rewrite based on system or user-defined rules)
  • query optimization
  • execution
would be performed or not? Also, where in the documentation can I found out which of the above phases would be performed?

For example, for a query such as the following:

select x,y from test1 where 1=0;

Thanks
P

pgsql-general by date:

Previous
From: johncarter
Date:
Subject: [GENERAL] EDB to PST Converter
Next
From: Merlin Moncure
Date:
Subject: Re: [GENERAL] a JOIN to a VIEW seems slow