search

quantified-uncertainty / metaforecast

Fetch forecasts from prediction markets/forecasting platforms to make them searchable. Integrate these forecasts into other services.
https://metaforecast.org/
MIT License
56 stars 5 forks source link

history.idref index #102

Closed berekuk closed 10 months ago

berekuk commented 10 months ago

Fix for #101.

Turns out neither Postgres or Prisma doesn't create an index on foreign keys, and we did full table scans on all from history where idref="..." queries.

I've already applied this migration in prod.

vercel[bot] commented 10 months ago

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name Status Preview Updated (UTC)
metaforecast ✅ Ready (Inspect) Visit Preview Aug 8, 2023 0:43am