Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 6ED1B9FB32A
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Sun,  1 Apr 2007 07:22:23 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 85774-07 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Sun,  1 Apr 2007 07:22:17 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2])
	by postgresql.org (Postfix) with ESMTP id B30449FB2E8
	for <pgsql-performance@postgresql.org>;
	Sun,  1 Apr 2007 07:22:17 -0300 (ADT)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id 30CDA3090A; Sun,  1 Apr 2007 12:22:16 +0200 (MET DST)
From: Ron Mayer <rm_pg@cheapcomplexdevices.com>
X-Newsgroups: pgsql.performance
Subject: Re: scalablility problem
Date: Sun, 01 Apr 2007 03:22:08 -0700
Organization: Hub.Org Networking Services
Lines: 12
Message-ID: <460F87D0.7090800@cheapcomplexdevices.com>
References: <460D7220.9010302@cse.ohio-state.edu>
	<23586.1175289138@sss.pgh.pa.us>
	<460D8371.7080405@cse.ohio-state.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@news.hub.org
To: Xiaoning Ding <dingxn@cse.ohio-state.edu>
User-Agent: Icedove 1.5.0.10 (X11/20070307)
In-Reply-To: <460D8371.7080405@cse.ohio-state.edu>
To: pgsql-performance@postgresql.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200704/1
X-Sequence-Number: 23878

Xiaoning Ding wrote:
> Postgresql is 7.3.18. [...]
> 1 process takes 0.65 second to finish.

> I update PG to 8.2.3. The results are [...] now.
> 1 process :    0.94 second

You sure about your test environment?  Anything else
running at the same time, perhaps?

I'm a bit surprised that 8.2.3 would be 40% slower than 7.3.18
even in the single process case.