Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 2D742632741 for ; Fri, 3 Sep 2010 05:15:56 -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 75196-04 for ; Fri, 3 Sep 2010 08:15:47 +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 66D7C63218A for ; Fri, 3 Sep 2010 05:15:48 -0300 (ADT) Received: by mail.sdb.it (Postfix, from userid 500) id 08EA18127; Fri, 3 Sep 2010 10:15:47 +0200 (CEST) Received: from geronimo.sdb.it (geronimo.sdb.it [10.101.1.20]) by mail.sdb.it (Postfix) with ESMTP id 03715811D; Fri, 3 Sep 2010 10:15:47 +0200 (CEST) Received: from mailtech.sdb.it (sdbit-srv01.sdb.it [10.118.122.250]) by geronimo.sdb.it (Postfix) with ESMTP id 3D71E3808A5; Fri, 3 Sep 2010 10:15:27 +0200 (CEST) Received: from [10.118.101.88] (silviob.sdb.it [10.118.101.88]) by mailtech.sdb.it (Postfix) with ESMTP id E2D0558ABC; Fri, 3 Sep 2010 10:15:46 +0200 (CEST) Message-ID: <4C80AEB1.9000402@tech.sdb.it> Date: Fri, 03 Sep 2010 10:15:45 +0200 From: Silvio Brandani User-Agent: Thunderbird 2.0.0.24 (Windows/20100228) MIME-Version: 1.0 To: Tom Lane Cc: 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.011 tagged_above=-10 required=5 tests=BAYES_20=-0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/33 X-Sequence-Number: 35577 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 > > I trace all the sql executed by application in the logfile then executed in psql and it works. -- Silvio Brandani Infrastructure Administrator SDB Information Technology Phone: +39.055.3811222 Fax: +39.055.5201119 --- 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. --