postgres concurently - ghdrako/doc_snipets GitHub Wiki

CONCURENTLY keyword make operation safe for running system

  • Adding index
  • Dropping index
  • Rebuilding index (reindexing)
  • Adding partition
  • Detaching partition