On Wednesday 17 December 2008, Peter Eisentraut said something like: > Because the TRUNCATE commands are taking out an exclusive lock on the > tables. > > > My understanding of MVCC is that I should be able to query against > > those tables while these insert loops are in their transaction. > > You get the MVCC behavior if you use DELETE instead of TRUNCATE. > TRUNCATE is specifically designed for better speed and less > concurrency. It's your choice. OK, that makes sense. There was nothing on the TRUNCATE page to suggest that TRUNCATE would lock the tables. Maybe an addition to the documentation is in order? Where do I go to suggest that? Thanks again! j -- Joshua Kugler Part-Time System Admin/Programmer http://www.eeinternet.com PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
