X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id BA8209DCAA8 for ; Mon, 5 Dec 2005 11:45:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74498-07 for ; Mon, 5 Dec 2005 11:45:28 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtpgw.computec.de (smtpgw.computec.de [212.123.108.8]) by postgresql.org (Postfix) with ESMTP id 6C1219DCADF for ; Mon, 5 Dec 2005 11:45:21 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by smtpgw.computec.de (Postfix) with ESMTP id 3177855A69; Mon, 5 Dec 2005 16:45:26 +0100 (CET) Received: from smtpgw.computec.de ([127.0.0.1]) by localhost (localhost [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 11803-01-82; Mon, 5 Dec 2005 16:45:25 +0100 (CET) Received: from HERMES.computec.de (unknown [192.168.0.22]) by smtpgw.computec.de (Postfix) with ESMTP id C54F055A60; Mon, 5 Dec 2005 16:45:25 +0100 (CET) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Date: Mon, 5 Dec 2005 16:45:25 +0100 Message-ID: <28011CD60FB1724DBA4442E38277F6264A6C4E@hermes.computec.de> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PERFORM] Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Thread-Index: AcX5rhqelz8jkDwsSIeszzJIp1ZFrwAAGHxAAAERLmA= From: "Markus Wollny" To: "Tom Lane" Cc: X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at computec.de X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.279 required=5 tests=[AWL=-0.640, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44] X-Spam-Score: 1.279 X-Spam-Level: * X-Archive-Number: 200512/127 X-Sequence-Number: 15948 =20 > -----Urspr=FCngliche Nachricht----- > Von: pgsql-performance-owner@postgresql.org=20 > [mailto:pgsql-performance-owner@postgresql.org] Im Auftrag=20 > von Markus Wollny > Gesendet: Montag, 5. Dezember 2005 16:41 > An: Tom Lane > Cc: pgsql-performance@postgresql.org > Betreff: Re: [PERFORM] Queries taking ages in PG 8.1, have=20 > been much faster in PG<=3D8.0=20 > an additional 230.328 rows in the answers-table. That was supposed to read 230,328 rows, sorry.