"Daniel Verite" <daniel@xxxxxxxxxxxxxxxx> writes: > Tom Lane wrote: >> 1. Performance. The cost of #2 is very large, and the number of cases >> where you actually need it is not. > Per Dean's explanation upthread, It looks like an additional cost for #2 > would occur mostly when temporary conflicts occur, that is, when it's needed. I'm not sure where you got that from his explanation, but it's not the case. The problem with any type of delayed verification is that it requires a second index search, on top of the one you already did while making your index entry. This occurs whether or not there is any conflict. The problem is especially acute when you have an update or insert affecting a large fraction of the table. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
