CenterForOpenScience / SHARE

SHARE is building a free, open, data set about research and scholarly activities across their life cycle.
http://share-research.readthedocs.io/en/latest/index.html
Apache License 2.0
100 stars 58 forks source link

[SHARE-1045] Speed up OAI feed (for real this time) #746

Closed aaxelb closed 6 years ago

aaxelb commented 6 years ago

Using a subquery looked faster on staging, but still times out on production. Instead, do two queries so postgres doesn't get confused trying to optimize across both of them.