Greg Smith <[EMAIL PROTECTED]> writes:
> The next time I'm doing some performance testing I'll try to quantify how 
> much damage the expensive ones do by playing with pg_config_manual.h. 
> Normally I'm testing with 1GB+ of shared_buffers which makes the current 
> assert scheme unusable.

There is a commit-time scan of the buffers for the sole purpose of
asserting a few things about their state.  That's one of the things
we'd need to turn off for a "cheap asserts only" mode I think.

If you want to try to quantify what "cheap asserts" might do, you
should pull out the #ifdef USE_ASSERT_CHECKING code here:
        check_list_invariants in list.c
        the loops in AtEOXact_Buffers and AtEOXact_LocalBuffers
        the loop in AtEOXact_CatCache
        the test that makes AtEOXact_RelationCache scan the relcache
                even when !need_eoxact_work
in addition to the memory-related stuff.

                        regards, tom lane

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to