Improve performance of delete device messages query

[MatMaul]

cf #16479.

Signed-off-by: Mathieu Velten [email protected]

Pull Request Checklist

• Pull request is based on the develop branch
• Pull request includes a changelog file. The entry should:
  • Be a short description of your change which makes sense to users. "Fixed a bug that prevented receiving messages from other servers." instead of "Moved X method from EventStore to EventWorkerStore.".
  • Use markdown where necessary, mostly for code blocks.
  • End with either a period (.) or an exclamation mark (!).
  • Start with a capital letter.
  • Feel free to credit yourself, by adding a sentence "Contributed by @github_username." or "Contributed by [Your Name]." to the end of the entry.
• Pull request includes a sign off
• Code style is correct
  (run the linters)

[MatMaul]

I am getting less rows deleted with this new query (10 instead of 12), I need to check why. All is fine.
cf #16479 (comment) for more infos and PG plans for old and new queries.

[MatMaul]

I think this is fine so undrafting it, but it may be useful to check a plan on pg11 with the new query.

[erikjohnston]

Woo, thanks!