Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A63076318F3 for ; Fri, 3 Sep 2010 04:33:16 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 23795-10 for ; Fri, 3 Sep 2010 07:33:09 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.sdb.it (mail.sdb.it [212.141.11.2]) by mail.postgresql.org (Postfix) with ESMTP id 1C03D6310AC for ; Fri, 3 Sep 2010 04:33:09 -0300 (ADT) Received: by mail.sdb.it (Postfix, from userid 500) id E37AE8129; Fri, 3 Sep 2010 09:33:07 +0200 (CEST) Received: from geronimo.sdb.it (geronimo.sdb.it [10.101.1.20]) by mail.sdb.it (Postfix) with ESMTP id DE3C380F5; Fri, 3 Sep 2010 09:33:07 +0200 (CEST) Received: from mailtech.sdb.it (sdbit-srv01.sdb.it [10.118.122.250]) by geronimo.sdb.it (Postfix) with ESMTP id 7E6903808AF; Fri, 3 Sep 2010 09:32:48 +0200 (CEST) Received: from [10.118.101.88] (silviob.sdb.it [10.118.101.88]) by mailtech.sdb.it (Postfix) with ESMTP id C688158ABC; Fri, 3 Sep 2010 09:33:07 +0200 (CEST) Message-ID: <4C80A4B2.4030602@tech.sdb.it> Date: Fri, 03 Sep 2010 09:33:06 +0200 From: Silvio Brandani User-Agent: Thunderbird 2.0.0.24 (Windows/20100228) MIME-Version: 1.0 To: Tom Lane , pgsql-admin@postgresql.org Subject: Re: out of memory error 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> <23468.1283440142@sss.pgh.pa.us> In-Reply-To: <23468.1283440142@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Private-Material: Please read notice X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.51 tagged_above=-10 required=5 tests=BAYES_05=-0.5, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/32 X-Sequence-Number: 35576 Tom Lane ha scritto: > 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 > > Is it possible to check the query plan of an odbc application ?? maybe tracing in the logfile or something else , I know the plan of the query I run on psql that works fine but I don't know the plan of the query with out of memory. Thanks a lot --- Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalitą amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelbene.com/news/privacy.html Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/codice_penale_616.html L'Azienda non si assume alcuna responsabilitą giuridica qualora pervengano da questo indirizzo messaggi estranei all'attivitą lavorativa o contrari a norme. --