Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2FEE864FEDB for ; Wed, 17 Sep 2008 16:28:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 02350-01-8 for ; Wed, 17 Sep 2008 16:28:49 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.225]) by postgresql.org (Postfix) with ESMTP id DDD8D650380 for ; Wed, 17 Sep 2008 16:23:58 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so4336915rvf.43 for ; Wed, 17 Sep 2008 12:23:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=AHxFnxTUNDQn6l1IYf7XtCHJ2mnzT9iZoZSWJYgCbaU=; b=TiYX8MQtYurW7h4Fs+E8N0ZTqxI7rtlMkPNLEewIUvHWpgo0VoVJnvBf9Yj9wWudnE u3/QYVJnEwR7ZbvLQK7wIa1AtD5+XDOCxRYKDrbdLZ++EWADqUl9taW2LB6Z7GjS+mPi 7leMGXqwtASSFN/kKWWBGFcI27T6EYQwBs/cg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=Xit49VIlug8bR+C131NoEdO7LqjO8Pa9zsF+oxl0nmPdPMZYhEpVdZW9xS3Of3501u 8Ng++sY+kQzBOZNv+UVwy0OTp/NjH8ssGN64f/V5YBfkVQ5IP9FMJ733zW0J79bJqW99 G3qWEIWsVSfzpafQ5sG4jnkZ0fmuY1571C4sw= Received: by 10.141.51.15 with SMTP id d15mr6779597rvk.106.1221677888062; Wed, 17 Sep 2008 11:58:08 -0700 (PDT) Received: by 10.141.74.11 with HTTP; Wed, 17 Sep 2008 11:58:07 -0700 (PDT) Message-ID: Date: Wed, 17 Sep 2008 12:58:07 -0600 From: "Scott Marlowe" To: "Kenneth Marshall" Subject: Re: Heavy postgres process Cc: Vivek_Sharan , "Guido Barosio" , "pgsql-admin@postgresql.org" In-Reply-To: <20080917183155.GA22468@it.is.rice.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <5465CC59A600E2408FFBF84350B938345031E95B93@AUSMELMBX01.ad.infosys.com> <5465CC59A600E2408FFBF84350B9383450F4933AB6@AUSMELMBX01.ad.infosys.com> <5465CC59A600E2408FFBF84350B9383450F4933C33@AUSMELMBX01.ad.infosys.com> <5465CC59A600E2408FFBF84350B9383450F4933E11@AUSMELMBX01.ad.infosys.com> <5465CC59A600E2408FFBF84350B9383450F4933E18@AUSMELMBX01.ad.infosys.com> <20080917183155.GA22468@it.is.rice.edu> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/177 X-Sequence-Number: 30270 On Wed, Sep 17, 2008 at 12:31 PM, Kenneth Marshall wrote: > Gee, > > Going to Oracle does seem a bit like throwing the baby out with > the bath water. Especially considering the performance increase from pgsql 7.4 to 8.3 is humongous. I'd say most operations are 2 to 4 times as fast and some operations are many 10 to 100 times faster. But for Vivek the real, first priority is to get his 7.4.5 server updated to the latest 7.4 version to make sure his data stays safe.