Postgres Pro
Downloads
Home   >   mailing lists

Re: 'now' runtime - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 'now' runtime
Date
Msg-id 16835.1112883267@sss.pgh.pa.us
Whole thread Raw
In response to 'now' runtime  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-hackers
Tree view 
Karel Zak <zakkr@zf.jcu.cz> writes:
> Why is there so different "Total runtime" for ('now'::text)::date) and
> '2005-04-06'::date ?

> I think both is constant during execution.

Not at all. text_date() is not immutable so it has to be applied during
execution.  The other one is just a constant.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)
Next
From: Tom Lane
Date:
Subject: Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)