Jakob van Santen

Very nice! I just ran across a case where I needed this, and implemented it myself without checking for open PRs first. Shame on me. Some improvements I might suggest:...

@mcoughlin asked me to take a look at this, and I could reproduce the slowdown that @lpsinger observed with the full ZTF field geometry and ~50 skymaps in the database...

While investigating temporary tables as a workaround for the `unnest(multirange)` size misestimation detailed above, @lpsinger found that the query planner can still flip back to the bad plan given enough...

I think the row estimate for unnest() may not have been the primary issue after all. A bigger problem, especially when the skymaptile table becomes large, is that postgres assumes...

This does not appear to be possible now, but will be once #146 is merged.

Hey, I can confirm that extinction 0.4.7 from PyPI works with current sncosmo: ``` > tox run -e py312 -r ... py312: commands[0] /Users/jakob/Documents/ZTF/forks/sncosmo/.tox/py312/tmp> pip freeze ... extinction==0.4.7 ... numpy==1.26.4...

Hey, now that [extinction has been packaged for numpy 2](https://github.com/sncosmo/extinction/pull/27), this appears to work: ``` > tox run -e py313 -r ... py313: commands[0] /Users/jakob/Documents/ZTF/forks/sncosmo/.tox/py313/tmp> pip freeze ... extinction==0.4.7 ......