On Thu, Mar 17, 2011 at 1:42 PM, J Sisson <sisso...@gmail.com> wrote: > On Thu, Mar 17, 2011 at 10:13 AM, Jeff <thres...@torgo.978.org> wrote: >> hey folks, >> >> Running into some odd performance issues between a few of our db boxes. > > We've noticed similar results both in OLTP and data warehousing conditions > here. > > Opteron machines just seem to lag behind *especially* in data > warehousing. Smaller > cache for sorting/etc... is what I'd always chalked it up to, but I'm > open to other theories > if they exist.
It's my theory as well - you know, this could be solved by JITting complex expressions. Bad cache behavior in application often comes as a side-effect of interpreted execution (in this case, of expressions, conditions, functions). A JIT usually solves this cache inefficiency. I know, adding any kind of JIT to pg could be a major task. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
