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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | alepaes - aldeia digital | 2009-02-09 12:24:02 | Re: Server memory exhausted on ODBC 8.3.0400 |
Previous Message | alepaes - aldeia digital | 2009-02-06 18:45:08 | Server memory exhausted on ODBC 8.3.0400 |