Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id B550F63374B
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 23 Mar 2010 05:15:04 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 33823-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 23 Mar 2010 08:14:49 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62])
	by mail.postgresql.org (Postfix) with ESMTP id C70566321C4
	for <pgsql-admin@postgresql.org>; Tue, 23 Mar 2010 05:14:53 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by hermes.vectorsf.com (Postfix) with ESMTP id EFCFC11C003C;
	Tue, 23 Mar 2010 09:14:50 +0100 (CET)
X-Virus-Scanned: amavisd-new at hermes.vectorsf.com
Received: from hermes.vectorsf.com ([127.0.0.1])
	by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id DVE6Pqninf-m; Tue, 23 Mar 2010 09:14:46 +0100 (CET)
Received: from [10.70.4.200] (unknown [10.70.4.200])
	(Authenticated sender: imartinez)
	by hermes.vectorsf.com (Postfix) with ESMTP id B8CA011C0015;
	Tue, 23 Mar 2010 09:14:46 +0100 (CET)
Subject: Re: Disparity between 8.1.18 and 8.2.14 performance wise
From: =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@vectorsf.com>
To: "Dai, Tino" <tdai@loc.gov>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: <1CA7FF980DA3824F9A5C31532B7A40DCC4B87E10@LCXCLMB01.LCDS.LOC.GOV>
References: <1CA7FF980DA3824F9A5C31532B7A40DCC4B87E10@LCXCLMB01.LCDS.LOC.GOV>
Content-Type: multipart/alternative; boundary="=-w2x6IlPpywMkCOiRcfzQ"
Date: Tue, 23 Mar 2010 09:14:47 +0100
Message-ID: <1269332087.8928.14.camel@deimos>
Mime-Version: 1.0
X-Mailer: Evolution 2.28.1 
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.149 tagged_above=-10 required=5 tests=AWL=0.449,
	BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201003/163
X-Sequence-Number: 33962


--=-w2x6IlPpywMkCOiRcfzQ
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

We had never problems when migrating from 8.1 to 8.2

Problems appear if you migrate to 8.3 or higher (due to explicit
conversions in data types and tsearch changes). But moving from 8.1 to
8.2 should be really easy and shouldn't suppose a problem. 

-----Original Message-----
From: Dai, Tino <tdai@loc.gov>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: [ADMIN] Disparity between 8.1.18 and 8.2.14 performance wise
Date: Mon, 22 Mar 2010 17:58:41 -0400


After many days of googling and referring to different web pages about performance, I'm
turning to this list for help. We have a third party application that is running on 8.1.11 and the
vendor has told us not to upgrade the database to 8.2. 



--=-w2x6IlPpywMkCOiRcfzQ
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.28.1">
</HEAD>
<BODY>
We had never problems when migrating from 8.1 to 8.2<BR>
<BR>
Problems appear if you migrate to 8.3 or higher (due to explicit conversions in data types and tsearch changes). But moving from 8.1 to 8.2 should be really easy and shouldn't suppose a problem. <BR>
<BR>
-----Original Message-----<BR>
<B>From</B>: Dai, Tino &lt;<A HREF="mailto:%22Dai,%20Tino%22%20%3ctdai@loc.gov%3e">tdai@loc.gov</A>&gt;<BR>
<B>To</B>: pgsql-admin@postgresql.org &lt;<A HREF="mailto:%22pgsql-admin@postgresql.org%22%20%3cpgsql-admin@postgresql.org%3e">pgsql-admin@postgresql.org</A>&gt;<BR>
<B>Subject</B>: [ADMIN] Disparity between 8.1.18 and 8.2.14 performance wise<BR>
<B>Date</B>: Mon, 22 Mar 2010 17:58:41 -0400<BR>
<BR>
<PRE>
After many days of googling and referring to different web pages about performance, I'm
turning to this list for help. We have a third party application that is running on 8.1.11 and the
vendor has told us not to upgrade the database to 8.2. 
</PRE>
<BR>
</BODY>
</HTML>

--=-w2x6IlPpywMkCOiRcfzQ--