I'm doing a large "insert into .. select * from CSVREAD ...", which is in a transaction. It seems to be blocking readers, regardless of whether MVCC is enabled. Is this expected? If I understand the threads on MVCC, it will allow readers to execute concurrent with a running transaction, but individual queries are still serialized. Is that right? Does that mean the table is locked for the duration of the "insert into .." ?
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
