Re: Fun little performance IMPROVEMENT...

grant@amadensor.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@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books