Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 21DF911C7C00
	for <pgsql-performance@postgresql.org>;
	Wed,  7 Dec 2011 00:12:06 -0400 (AST)
Received: from smtp.01.com ([216.115.88.169])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <josh@agliodbs.com>) id 1RY8rR-0001xt-2f
	for pgsql-performance@postgresql.org; Wed, 07 Dec 2011 04:12:05 +0000
Received: from localhost (localhost.localdomain [127.0.0.1])
	by smtp-out-1.01.com (Postfix) with ESMTP id CF4C69D0231
	for <pgsql-performance@postgresql.org>;
	Tue,  6 Dec 2011 22:11:46 -0600 (CST)
X-Virus-Scanned: amavisd-new at smtp-out-1.01.com
Received: from smtp.01.com ([127.0.0.1])
	by localhost (smtp-out-1.01.com [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id DgXJ0gq7oiLy for <pgsql-performance@postgresql.org>;
	Tue,  6 Dec 2011 22:11:46 -0600 (CST)
Received: from localhost.localdomain (localhost.localdomain [127.0.0.1])
	by smtp-out-1.01.com (Postfix) with ESMTP id B0A549D055D
	for <pgsql-performance@postgresql.org>;
	Tue,  6 Dec 2011 22:11:46 -0600 (CST)
Received: from Sidney-Stratton.local (unknown [70.88.219.5])
	by smtp-out-1.01.com (Postfix) with ESMTPSA id 6B6F69D0231
	for <pgsql-performance@postgresql.org>;
	Tue,  6 Dec 2011 22:11:46 -0600 (CST)
Message-ID: <4EDEE781.90801@agliodbs.com>
Date: Tue, 06 Dec 2011 23:11:45 -0500
From: Josh Berkus <josh@agliodbs.com>
Organization: PostgreSQL Experts Inc.
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US;
	rv:1.9.2.24) Gecko/20111103 Lightning/1.0b2 Thunderbird/3.1.16
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Response time increases over time
References: 
 <CAOryeA1Wbi3p51tsJQKd79twV0bK2D+6pKv13eHEWdJnYth+bA@mail.gmail.com>
In-Reply-To: 
 <CAOryeA1Wbi3p51tsJQKd79twV0bK2D+6pKv13eHEWdJnYth+bA@mail.gmail.com>
X-Enigmail-Version: 1.1.1
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201112/53
X-Sequence-Number: 45852

On 12/6/11 4:30 PM, Havasv=C3=B6lgyi Ott=C3=B3 wrote:
> Is there so much difference between 8.4 and 9.1, or is this something e=
lse?
> Please tell me if any other info is needed.

It is fairly likely that the difference you're seeing here is due to
improvements made in checkpointing and other operations made between 8.4
and 9.1.

Is there some reason you didn't test 9.1 on Linux to compare the two?

--=20
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com