Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 084559FB5D4 for ; Mon, 2 Jul 2007 11:30:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 58160-02 for ; Mon, 2 Jul 2007 11:30:01 -0300 (ADT) X-Greylist: delayed 00:06:39.255433 by SQLgrey-1.7.4 Received: from web56405.mail.re3.yahoo.com (web56405.mail.re3.yahoo.com [216.252.111.84]) by postgresql.org (Postfix) with SMTP id 468869FB396 for ; Mon, 2 Jul 2007 11:30:10 -0300 (ADT) Received: (qmail 46855 invoked by uid 60001); 2 Jul 2007 14:23:29 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=00m/XZzC7dhFKYgcnrtC+uBzff2hcIkwDb5c1Kxt+WUCh8taTHBQ0RuPEex78tYHWPzq7qOQCDaI/xZp+QJAHtlzF7vvKsXMKqirkj7vMz9IpRW6ZEHhhlvJYR/LB4Tef0evV8j3L5JRBIuLPrKYakK/eb0mVwc8sh4j3iF59p0=; X-YMail-OSG: UXUblGQVM1kLxu.M19m0T12nQWiTBT1W86IVK1C_Bofkd2fDfM0r5kjKWWb_22Xc3T7H9XUfqezCRfuzm9OHbJiTG2t7k9ZNtrKf8UM9_1Hc.ljNNqHdHN39vMe.ycA- Received: from [198.119.134.32] by web56405.mail.re3.yahoo.com via HTTP; Mon, 02 Jul 2007 07:23:29 PDT Date: Mon, 2 Jul 2007 07:23:29 -0700 (PDT) From: Jessica Richard Subject: select * from a 3M-row table very slow To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1812753107-1183386209=:45901" Content-Transfer-Encoding: 8bit Message-ID: <265346.45901.qm@web56405.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.303 tagged_above=0 required=5 tests=AWL=0.172, BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447, HTML_30_40=0.374, HTML_MESSAGE=0.001 X-Spam-Level: * X-Archive-Number: 200707/7 X-Sequence-Number: 25988 --0-1812753107-1183386209=:45901 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Is there anything that can make this faster? Is there any memory config (postgres and OS) that can be tuned? it came back very quick under Informix. Thanks. --------------------------------- Looking for earth-friendly autos? Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center. --0-1812753107-1183386209=:45901 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Is there anything that can make this faster? Is there any memory config (postgres and OS) that can be tuned? it came back very quick under Informix.
Thanks.


Looking for earth-friendly autos?
Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center. --0-1812753107-1183386209=:45901--