Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 9B9981335B36 for ; Wed, 29 Sep 2010 21:02:04 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 34094-01 for ; Thu, 30 Sep 2010 00:01:58 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web111306.mail.gq1.yahoo.com (web111306.mail.gq1.yahoo.com [67.195.15.161]) by mail.postgresql.org (Postfix) with SMTP id 3AD3C133655C for ; Wed, 29 Sep 2010 21:01:56 -0300 (ADT) Received: (qmail 14561 invoked by uid 60001); 30 Sep 2010 00:01:56 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1285804916; bh=Pb9WFJGm+PWeyJ+oZNLZRbxiBuZNsfHFfw2H81/NoK8=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=DUIxTiU0SHEIbcclLDjBbzW7EWtTprVpJZvtCukQHsC0XOYDIYLiSAVrNpzIZ9BLzuDxLY0bd59WGH7HqMlq3uXfeX9y+7XwRGPutnvR8PnQe5pJg82IMVUsW4zCuBww6Yyor3ssx7327WIDyrk59MF1EaAKcf7A7BSOYtB7ql8= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=NoLeK5k4MmMhk4Qb3KrDgdZxkTWCEpg8o+lzVIdYrzAHKhu70/CgHAh3HLvqDSfjT3I/qJwpGQK/LgxiLGc5W8JoUlUKOf4097AHYH7ep+bhqsTjvaA71Xt+6punJZVaCTLGz3dkQOLqqzj1YSHZmrFhSQ4hyaxO1OuRx+Ctju4=; Message-ID: <378136.12565.qm@web111306.mail.gq1.yahoo.com> X-YMail-OSG: RVrh6gUVM1kukl44fAIFWEvWJK9eQkSm.FCCGUGNiMjGQY8 Jkr4- Received: from [24.34.116.83] by web111306.mail.gq1.yahoo.com via HTTP; Wed, 29 Sep 2010 17:01:55 PDT X-Mailer: YahooMailClassic/11.4.9 YahooMailWebService/0.8.105.279950 Date: Wed, 29 Sep 2010 17:01:55 -0700 (PDT) From: Andy Subject: Performance improvements/regressions from 8.4 to 9.0? To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/209 X-Sequence-Number: 40412 Hi, Are there any significant performance improvements or regressions from 8.4 to 9.0? If yes, which areas (inserts, updates, selects, etc) are those in? In a related question, is there any public data that compares the performances of various Postgresql versions? Thanks