David McDonald 33d85322c9 Change sql to chunk by hour to remove old email notifications ...

So since removing the subquery in the previous commit, we now are doing
all of the inserts using offsets and limits to group by 10,000 and deleting
all records in a single query (which could be up to as many as 10
million rows).

We want to avoid doing this, because both of these ways we think are
going to result in expensive queries. Therefore we have introduced our
own chunking of the notifications by hour periods meaning we do not need
to use offset and limits.

We estimate that GOV.UK email will at most send 600,000 notifications
per hour (175 per second * 60 * 60).

2020-03-20 16:52:09 +00:00

..

app

Change sql to chunk by hour to remove old email notifications

2020-03-20 16:52:09 +00:00

__init__.py

Change variable name to make more descriptive

2020-02-20 15:48:15 +00:00

conftest.py

remove monkeypatch

2020-01-06 17:53:56 +00:00

test_all_queues_used.py

…