Hello every body,I just discover a big not only big huge difference between NOW() and CURRENT_DATE.
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 0.065 ms tx david