| From: | Ludek Finstrle <luf(at)pzkagis(dot)cz> |
|---|---|
| To: | Tomas Skäre <tomas(at)nocrew(dot)org> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Out of memory troubles with version 8.01.01.02 |
| Date: | 2005-12-13 15:53:09 |
| Message-ID: | 20051213155309.GA6005@soptik.pzkagis.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
> > I know about this limitation. There is problem ODBC keep all rows
> > in memory (+ result from libpq = 2 x result). Please try check
> > Use Declare/Fetch option. There is no twice result in memory in psqlODBC.
> > If it doesn't help you can try older releases which mayde do not do this.
> > Please try 8.00.X or even 7.03.209 (if you find it somewhere).
> > I know we're suggesting 8.01.X but few people work with so big
> > datasets.
>
> Does it keep everything in memory when using cursors too?
New releases (8.01.X) keep everything in memory. There is no option
to change it. I have an idea how to do it but time ...
Older releases (8.00.X or 7.X - not based on libpq) maybe do not keep
everything in memory.
Regards,
Luf
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Filip Wuytack | 2005-12-13 17:03:31 | Re: Out of memory troubles with version 8.01.01.02 |
| Previous Message | =?iso-8859-1?q?Tomas_Sk=E4re?= | 2005-12-13 15:22:02 | Re: Out of memory troubles with version 8.01.01.02 |