Skip site navigation (1) Skip section navigation (2)

Vacuum and inserts

From: "Fontenot, Paul" <Paul(dot)Fontenot(at)bannerhealth(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Vacuum and inserts
Date: 2003-06-18 16:16:50
Message-ID: 230BCAB977308F43BD851AFAE55A86415E18DE@phx01018.bannerhealth.com (view raw or flat)
Thread:
Lists: pgsql-novice
When doing a vacuum full on a database, what happens to an insert? 
Does it spool the inserts up somewhere? 
Does it insert them during the vacuum?

I am assuming they are "spooled" up somewhere until the vacuum is
completed but I really don't know.

 ***PRIVILEGED & CONFIDENTIAL***
Unless expressly stated otherwise, this message (and any attachment(s)
thereto) is confidential and may be privileged. It is intended for the
addressee(s) only. If you are not an addressee, any disclosure or
copying of the contents of this e-mail or any action taken (or not
taken) in reliance on it is strictly prohibited. If you are not an
addressee, please inform sender immediately and delete this message from
your system. 

Responses

pgsql-novice by date

Next:From: Josh BerkusDate: 2003-06-18 16:24:02
Subject: Re: sql question (hopefully)
Previous:From: Josh BerkusDate: 2003-06-18 15:13:30
Subject: Re: sql question (hopefully)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group