Обсуждение: "Create index" lock type
What kind of lock does the “create index” (not concurrent) command take? From the documentation, it says that it blocks out writes. But I’m not sure how to find the exact lock type in the documentation.
The reason I’m asking is because I’m trying to see if it conflicts with the lock taken by autovacuum (to prevent wraparound), “SHARE UPDATE EXCLUSIVE”.
This email message is confidential, may be legally privileged and is intended for the exclusive use of the addressee. If you received this message in error or are not the intended recipient, you should destroy the email message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained. Please inform us of the delivery error by return email. Thank you for your cooperation.
Le présent message électronique est confidentiel et peut être couvert par le secret professionnel. Il est à l’usage exclusif du destinataire. Si vous recevez ce message par erreur ou si vous n’en êtes pas le destinataire prévu, vous devez détruire le message et toute pièce jointe ou copie et vous êtes tenu de ne pas conserver, distribuer, divulguer ni utiliser tout renseignement qu’il contient. Veuillez nous informer de toute erreur d’envoi en répondant à ce message. Merci de votre collaboration.
What kind of lock does the “create index” (not concurrent) command take? From the documentation, it says that it blocks out writes. But I’m not sure how to find the exact lock type in the documentation.
The reason I’m asking is because I’m trying to see if it conflicts with the lock taken by autovacuum (to prevent wraparound), “SHARE UPDATE EXCLUSIVE”.