Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 1F71E632484 for ; Thu, 2 Sep 2010 12:09:11 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 25991-09 for ; Thu, 2 Sep 2010 15:09:04 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 0B6D96310AC for ; Thu, 2 Sep 2010 12:09:03 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o82F92GZ023469; Thu, 2 Sep 2010 11:09:02 -0400 (EDT) To: Silvio Brandani cc: pgsql-admin@postgresql.org Subject: Re: out of memory error In-reply-to: <4C7FBD34.2030607@tech.sdb.it> References: <288793.40690.qm@web39707.mail.mud.yahoo.com> <4C5BC43B.7050503@tech.sdb.it> <4C5BF885.9060105@tech.sdb.it> <4C7F9DA6.6080606@tech.sdb.it> <4C7FA8B7.4000702@tech.sdb.it> <22549.1283437674@sss.pgh.pa.us> <4C7FBD34.2030607@tech.sdb.it> Comments: In-reply-to Silvio Brandani message dated "Thu, 02 Sep 2010 17:05:24 +0200" Date: Thu, 02 Sep 2010 11:09:02 -0400 Message-ID: <23468.1283440142@sss.pgh.pa.us> From: Tom Lane 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, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/14 X-Sequence-Number: 35558 Silvio Brandani writes: > Tom Lane ha scritto: >> Is it really the *exact* same query both ways, or are you doing >> something like parameterizing the query in the application? > Is it exactly the same, the query text is from the postgres log. > I just try it in test environment and we have same situazione : psql it > works, from application (odbc) do not. Hm, there's got to be something different between the two cases. Maybe the odbc application is issuing some SET commands that change the chosen plan? regards, tom lane