Ever so slightly faster intervals in postgres
When working with dates in postgres I often construct an interval like so:
> select (2 || ' days')::interval;
2 daysWhich is fine! But there's an alternative that's ever so slightly faster.
> select 2 * '1 day'::interval;
2 daysThe time difference can be seen over large quantities of data, like 10 million.
> select (x || ' days')::interval from generate_series(1, 10000000) as x;
...
Time: 10437.314 ms > select x * '1 days'::interval from generate_series(1, 10000000) as x;
...
Time: 7831.568 msMicrobenchmarking in action! Remember, take all microbenchmarks with a grain of salt.
Tweet