Re: Fun little performance IMPROVEMENT...

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: grant(at)amadensor(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Fun little performance IMPROVEMENT...
Date: 2011-01-21 20:19:21
Message-ID: 4D39EA49.5040809@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

grant(at)amadensor(dot)com wrote:
> This was on a 4 CPU Xen virtual machine running
> 8.1.22 on CENTOS.
>

You're not going to get anyone to spend a minute trying to figure what's
happening on virtual hardware with an ancient version of PostgreSQL. If
this was an actual full test case against PostgreSQL 8.4 or later on a
physical machine, it might be possible to draw some conclusions about it
that impact current PostgreSQL development. Note where 8.1 is on
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy for
example.

--
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2011-01-21 20:22:24 Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
Previous Message grant 2011-01-21 20:18:55 Re: Fun little performance IMPROVEMENT...