Hannu Krosing <[EMAIL PROTECTED]> writes: > What I have in mind would be something like this to get both SNAP2 and > commit between any transactions:
> LOOP: > LOCK AGAINST STARTING NEW TRANSACTIONS I can hardly credit that "let's block startup of ALL new transactions" is a more desirable restriction than "let's block writers to the table we wish to reindex". regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq