Re: Vacuum and inserts - Mailing list pgsql-novice

From Tom Lane
Subject Re: Vacuum and inserts
Date
Msg-id 22258.1055953711@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum and inserts  ("Fontenot, Paul" <Paul.Fontenot@bannerhealth.com>)
List pgsql-novice
"Fontenot, Paul" <Paul.Fontenot@bannerhealth.com> writes:
> When doing a vacuum full on a database, what happens to an insert?
> Does it spool the inserts up somewhere?

No, the would-be insert is simply blocked until the vacuum completes
(because the latter holds an exclusive lock on the table).

            regards, tom lane

pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: sql question (hopefully)
Next
From: "Juliet May"
Date:
Subject: Documentation Tools