[EMAIL PROTECTED] writes: > 7.4beta5 offers more throughput. One significant difference I see is in > the oprofile for the database. For the additional 7% increase in the > metric, there are about 32% less ticks in SearchCatCache.
Hmm. I have been profiling PG for some years now, and I cannot remember ever seeing a profile in which SearchCatCache topped everything else (the usual suspects for me are palloc/pfree support code). Can you give any explanation why it looks like that? Can your profiling code tell where the hotspot call sites of SearchCatCache are? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend