Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2AF6763381E for ; Wed, 13 Jan 2010 12:15:23 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 87086-09 for ; Wed, 13 Jan 2010 16:15:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f213.google.com (mail-bw0-f213.google.com [209.85.218.213]) by mail.postgresql.org (Postfix) with ESMTP id 603C86335CF for ; Wed, 13 Jan 2010 12:15:12 -0400 (AST) Received: by bwz5 with SMTP id 5so15563665bwz.3 for ; Wed, 13 Jan 2010 08:15:10 -0800 (PST) MIME-Version: 1.0 Received: by 10.204.5.75 with SMTP id 11mr1045479bku.20.1263399310281; Wed, 13 Jan 2010 08:15:10 -0800 (PST) In-Reply-To: <603c8f071001130811g22387928g72262638532370e5@mail.gmail.com> References: <3073cc9b0908191745o3dc63d95q6b9308ef5bd199f2@mail.gmail.com> <3073cc9b1001111015t3888cbbex7171d61b952218da@mail.gmail.com> <603c8f071001111107v75276375g4d626dfc0efd8dc4@mail.gmail.com> <3073cc9b1001111114j7ddacd56p8966f9d61997a8b@mail.gmail.com> <3073cc9b1001111116x53427c9bm1e448128a3b4f6c6@mail.gmail.com> <18803.1263241120@sss.pgh.pa.us> <3073cc9b1001122231m1a15d187lae2a8096a813361b@mail.gmail.com> <603c8f071001130723v634cb3c3u1604ea69efb04e91@mail.gmail.com> <10990.1263397358@sss.pgh.pa.us> <603c8f071001130811g22387928g72262638532370e5@mail.gmail.com> From: Jaime Casanova Date: Wed, 13 Jan 2010 11:14:55 -0500 Message-ID: <3073cc9b1001130814t79b313dk4377996dee0ac521@mail.gmail.com> Subject: Re: [PERFORMANCE] work_mem vs temp files issue To: Robert Haas Cc: Tom Lane , decibel , psql performance list Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.078 tagged_above=-10 required=5 tests=BAYES_05=-1.11, FH_DATE_PAST_20XX=3.188 X-Spam-Level: ** X-Archive-Number: 201001/253 X-Sequence-Number: 37133 On Wed, Jan 13, 2010 at 11:11 AM, Robert Haas wrote= : > > Well, what about when we're just doing EXPLAIN, not EXPLAIN ANALYZE? > It'll add another line to the output for the expected number of > batches. > and when we are in EXPLAIN ANALYZE the real number as well? --=20 Atentamente, Jaime Casanova Soporte y capacitaci=C3=B3n de PostgreSQL Asesor=C3=ADa y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157