Skip site navigation (1) Skip section navigation (2)

Re: Server memory exhausted on ODBC 8.3.0400

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: alepaes - aldeia digital <alepaes(at)aldeiadigital(dot)com(dot)br>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Server memory exhausted on ODBC 8.3.0400
Date: 2009-02-07 17:48:13
Message-ID: 498DC95D.4080507@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
alepaes - aldeia digital wrote:
> Hi,
> 
> Last weekend, I update 2 customers servers with the latest Postgresql 
> 8.3.5 vrsion. The databases in each customer have +/- 50GB  of data.
> 
> I changed some ODBCs versions in clients machines from 7.3.0208 to 
> 8.3.0400.
> In this machines, when I run some reports (thats run million of small 
> queries), the Postgresql server crashes because this processes use all 
> physical and swap memory in the server.
> 
> If I disable both 'Use declare/fetch' and 'Updatable Cursor', the error 
> does not occurs. I don't need the 'Updatable Cursors', but the 'Use 
> Declare Fetch' is crucial to me.
> In ODBC 7.3.0208, with this option enabled, the error doesn't occurs.

Does your code close the statements used in the applications?

regards,
Hiroshi Inoue

In response to

Responses

pgsql-odbc by date

Next:From: alepaes - aldeia digitalDate: 2009-02-09 12:24:02
Subject: Re: Server memory exhausted on ODBC 8.3.0400
Previous:From: alepaes - aldeia digitalDate: 2009-02-06 18:45:08
Subject: Server memory exhausted on ODBC 8.3.0400

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group