Thomas Kellerer <spam_eater@xxxxxxx> writes: > So my question is: why is comparing a timestamp to a date so much slower? The date has to be up-converted to a timestamptz (not timestamp). I think the expensive part of that is determining what timezone applies, in particular whether DST is active. You could try it with "localtimestamp" (no parens) instead of "now()" to see how it performs with a non-tz timestamp. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
