Re: OSDL DBT-2 w/ PostgreSQL 7.3.4 and 7.4beta5
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: markw@osdl.org
Cc: pgsql-hackers@postgresql.org, osdldbt-general@lists.sourceforge.net
Date: 2003-11-01T05:19:22Z
Lists: pgsql-hackers
markw@osdl.org 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