Skip to content

Instantly share code, notes, and snippets.

@sbaltus

sbaltus/refresh_concurrently.sql

Created January 27, 2018 19:00
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save sbaltus/88c85a1416939b3087c37d5cf91a3c7f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save sbaltus/88c85a1416939b3087c37d5cf91a3c7f to your computer and use it in GitHub Desktop.
Download ZIP
Refresh mat view
Raw
refresh_concurrently.sql
CREATE UNIQUE INDEX IF NOT EXISTS fomv_uq_jo_id ON job_offer_views_mv (job_offer_id) ;
REFRESH MATERIALIZED VIEW CONCURRENTLY job_offer_views_mv;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment