From rjessil@yahoo.com Mon Jul 2 14:30:17 2007 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-- From danieljunior@linuxmail.org Mon Jul 2 14:38:46 2007 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 766AA9FB5CA for ; Mon, 2 Jul 2007 11:38:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 73738-01 for ; Mon, 2 Jul 2007 11:38:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 3CDDE9FB396 for ; Mon, 2 Jul 2007 11:38:42 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from webmail-outgoing.us4.outblaze.com (webmail-outgoing.us4.outblaze.com [205.158.62.67]) by svr4.postgresql.org (Postfix) with ESMTP id 44C875AF93E for ; Mon, 2 Jul 2007 14:38:41 +0000 (GMT) Received: from unknown (unknown [192.168.9.180]) by webmail-outgoing.us4.outblaze.com (Postfix) with QMQP id BB0521800210 for ; Mon, 2 Jul 2007 14:31:05 +0000 (GMT) X-OB-Received: from unknown (205.158.62.131) by wfilter.us4.outblaze.com; 2 Jul 2007 14:31:05 -0000 Received: by ws5-1.us4.outblaze.com (Postfix, from userid 1001) id CBD8C4406E; Mon, 2 Jul 2007 14:31:05 +0000 (GMT) Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" MIME-Version: 1.0 From: =?iso-8859-1?B?RGFuaWVsIEFsduNvIENhcnZhbGhvIEr6bmlvcg==?= To: pgsql-admin@postgresql.org Date: Mon, 2 Jul 2007 22:31:05 +0800 Subject: Re: select * from a 3M-row table very slow Received: from [200.214.130.18] by ws5-1.us4.outblaze.com with http for danieljunior@linuxmail.org; Mon, 2 Jul 2007 22:31:05 +0800 X-Originating-Ip: 200.214.130.18 X-Originating-Server: ws5-1.us4.outblaze.com Message-Id: <20070702143105.CBD8C4406E@ws5-1.us4.outblaze.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/8 X-Sequence-Number: 25989 Hi ! Tell us your hardware and software configurations. []s > ----- Original Message ----- > From: "Jessica Richard" > To: pgsql-admin@postgresql.org > Subject: [ADMIN] select * from a 3M-row table very slow > Date: Mon, 2 Jul 2007 07:23:29 -0700 (PDT) >=20 >=20 > Is there anything that can make this faster? Is there any memory=20 > config (postgres and OS) that can be tuned? it came back very quick=20 > under Informix. > Thanks. >=20 >=20 > --------------------------------- > Looking for earth-friendly autos? > Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center. > =3D --=20 Powered by Outblaze From AGuergolet@compugraf.com.br Mon Jul 2 16:36:02 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0EB599FBADD for ; Mon, 2 Jul 2007 13:36:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 37893-10 for ; Mon, 2 Jul 2007 13:35:48 -0300 (ADT) X-Greylist: delayed 00:31:48.150944 by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id D921B9FBC93 for ; Mon, 2 Jul 2007 13:35:46 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from smtp.compugraf.com.br (cgexc04.compugraf.com.br [200.194.112.27]) by svr4.postgresql.org (Postfix) with ESMTP id 5804D5AF03B for ; Mon, 2 Jul 2007 16:03:55 +0000 (GMT) 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: select * from a 3M-row table very slow Date: Mon, 2 Jul 2007 13:04:02 -0300 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] select * from a 3M-row table very slow Thread-Index: Ace8txMwhJdA9KXoR0yEpa/DCpxRtgACzmSw From: =?iso-8859-1?Q?Andr=E9_Jos=E9_Guergolet?= To: =?iso-8859-1?Q?Daniel_Alv=E3o_Carvalho_J=FAnior?= , X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200707/10 X-Sequence-Number: 25991 Please, send your query, table definition and indexes and the execution = plan. -----Original Message----- From: pgsql-admin-owner@postgresql.org = [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Daniel Alv=E3o = Carvalho J=FAnior Sent: segunda-feira, 2 de julho de 2007 11:31 To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] select * from a 3M-row table very slow Hi ! Tell us your hardware and software configurations. []s > ----- Original Message ----- > From: "Jessica Richard" > To: pgsql-admin@postgresql.org > Subject: [ADMIN] select * from a 3M-row table very slow > Date: Mon, 2 Jul 2007 07:23:29 -0700 (PDT) >=20 >=20 > Is there anything that can make this faster? Is there any memory=20 > config (postgres and OS) that can be tuned? it came back very quick=20 > under Informix. > Thanks. >=20 >=20 > --------------------------------- > Looking for earth-friendly autos? > Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center. > =3D -- Powered by Outblaze ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster