Re: vacuum and table locking

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



If you use the --no-table-lock flag from the contrib stuff, you can alleviate that...


On Fri, Apr 03, 2015 at 3:27 PM, Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:

On Apr 3, 2015, at 9:59 AM, John Scalia <jayknowsunix@xxxxxxxxx> 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, so it locks it the whole time. (Just went through this myself...)

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







--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux