Gordon Shannon <gordo169@xxxxxxxxx> writes: > I assume you can now see the plan? I uploaded it twice, once via gmail and > once on Nabble. Yeah, the Nabble one works. Now I'm even more confused, because the whole-row var seems to be coming from the outside of the nestloop, which is about the simplest possible case. > The number of matching rows on these queries is anything from 0 to 10000. I > don't think I can tell how many would have matched on the ones that > crashed. Although I suspect it would have been toward the 10000 end. I've > been trying to get a reproducable test case with no luck so far. No luck here either. A couple further questions --- do you think it's likely that you could have been over 10000 matches, ie, the LIMIT actually kicked in? Also, could there have been more than two concurrent updates acting on the same rows? 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
