postgres upgrade, upgrade extensions and rebuild indexes

serratus-bio / open-virome

monorepo for data explorer UI and APIs

http://openvirome.com/

GNU Affero General Public License v3.0

0 stars 0 forks source link

postgres upgrade, upgrade extensions and rebuild indexes #57

Closed almosnow closed 1 week ago

almosnow commented 1 month ago

... as per the recommendation

almosnow commented 1 month ago

and VACUUM, ...

lukepereira commented 1 month ago

ANALYZE would be good to run too, it sped up queries last time on serratus since it updates statistics used by the query planner https://stackoverflow.com/a/69206920