Re: vacuum and table locking - Mailing list pgsql-admin

From Scott Ribe
Subject Re: vacuum and table locking
Date
Msg-id 93CAB446-41FF-4032-935D-CBABFF233906@elevated-dev.com
Whole thread Raw
In response to vacuum and table locking  (John Scalia <jayknowsunix@gmail.com>)
Responses Re: vacuum and table locking
List pgsql-admin
On Apr 3, 2015, at 9:59 AM, John Scalia <jayknowsunix@gmail.com> wrote:
>
> So the lock should only be during this move, or does it lock the table for the entirety?

The entirety. It doesn't know how to track changes that occur during the copying to the new table and apply them after,
soit locks it the whole time. (Just went through this myself...) 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice







pgsql-admin by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: vacuum and table locking
Next
From: Scott Whitney
Date:
Subject: Re: vacuum and table locking