queue_classic icon indicating copy to clipboard operation
queue_classic copied to clipboard

Investigate PG 12+ CTE materialization

Open ukd1 opened this issue 2 years ago • 0 comments

Re:https://github.com/bensheldon/good_job/issues/65#issuecomment-1722391921

We need to investigate CTE materialization - we're expecting the default to be ok, but should test that vs explicitly on or off too and pick the fastest.

  • [ ] test perf for default
  • [ ] test perf for on
  • [ ] test perf for off
  • [ ] depending on results, decide if we push support min to PG 12, or introduce specific queries for > pg 12

ukd1 avatar Sep 17 '23 19:09 ukd1