Re: Explicit timestamp conversion very slow

"Hamby, Mark CONTRACTOR HAMBYM" <MARK.HAMBY@LEAVENWORTH.ARMY.MIL> writes:
> /* QUERY WITH EXPLICIT TIMESTAMP CONVERSION */
> /* DOES NOT USE INDEX AND IS VERY SLOW. */
> /* DOES ANYONE CARE? */

Nope.

> explain analyze
>             select count(*)
>             from truth_units
>             where time = timestamp '2002-08-15 10:00'
>             ;

"timestamp" is "timestamp with time zone" in 7.2.  So this is an
unindexable cross-datatype comparison.

            regards, tom lane