"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > Seriously, I am wondering about the performance hit of always checking > debug_assertions. > http://archives.postgresql.org/pgsql-hackers/2005-08/msg00389.php > indicates that even with debug_assertions=false, --enable-cassert has a > big performance impact.
That's because MEMORY_CONTEXT_CHECKING happens anyway --- it's not currently switched off by the GUC variable. I don't think we have any recent data point about the cost of Asserts per se, except your own report that it seems minimal. My thought is that it would be even more minimal if the tests of debug_assertion were removed ;-) ... except in association with Asserts that are actually testing an expensive-to-check condition, of which there are very few. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org