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

Reply via email to