Re: [PERFORM] NOW vs CURRENT_DATE

[Tino Wildenhain]

Hi,

dforum wrote:

Hello every body,



Did you already know about it and do you know why ?

DELETE FROM blacklist where bl_date < (NOW() - interval '2 DAY');
on 6 000 000 of records
699 ms

DELETE FROM blacklist where bl_date < (CURRENT_DATE - interval '2 DAY');
on 6 000 000 of records

I just discover a big not only big huge difference between NOW() and CURRENT_DATE.

Try that with a timestamp - column and use now() and current_timestamp
with a long running query and then compare min(column) max(column) in
both cases :-)

Regards
Tino

smime.p7s
Description: S/MIME Cryptographic Signature