"Create index" lock type

From: "Greg Rychlewski (LCL)" <Greg(dot)Rychlewski(at)loblaw(dot)ca>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: "Create index" lock type
Date: 2020-07-15 00:57:55
Message-ID: E36B5D5D-432D-4CEA-BEF0-9E3EFCDFBB57@loblaw.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David G. Johnston 2020-07-15 01:34:02 Re: "Create index" lock type
Previous Message Tom Lane 2020-07-14 06:02:35 Re: Postgres 12 - enable en_NZ.UTF-8