On Friday 06 August 2010 20:23:15 Tom Lane wrote: > Andres Freund <and...@anarazel.de> writes: > > The most prohibitively expensive part is the AtEOXact_Buffers check of > > running through all buffers and checking their pin count. And it makes > > $app's regression tests take thrice their time... > > > > Would somebody object agains putting those in an extra define so that > > those can be disabled in pg_config_manual? Or even disable it by default > > entirely... > Not a chance for the latter; this is an important sanity check that > catches real coding mistakes with some frequency. Ok.
> I'd be willing to consider a "half assert" mode that turns off some of > the most expensive checks, but AtEOXact_Buffers is hardly the only thing > that ought to be in that list. The CLOBBER_FREED_MEMORY and memory > context checking stuff is pretty durn expensive too. I personally have seen that catching way more bugs than the AtEOXact_Buffers check, but that might be because I have found mostly bugs in random c functions, not in pg stuff ;-) I will wait a bit and wait for more suggestions about expensive checks and/or other comments and will provide a patch for such a mode. Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers