Re: memory leak in psqlodb 08.04.0200

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: memory leak in psqlodb 08.04.0200
Date: 2010-05-21 03:19:04
Message-ID: 4BF5FBA8.10709@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Jaime Casanova wrote:
> Hi,
>
> When i use DTS from mssql to export data to postgres and the table is
>> 1million i get an error: Out of memory while reading tuples.
> I'm trying to understand the issue so i changed
> log_min_duration_statement=-1 in postgresql.conf to get all statements
> executed and i get
> BEGIN; INSERT one row sent from the dts RETURNING ctid; SELECT WHERE
> ctid; COMMIT;
>
> and when i select count(*) from table i get the rows it migrated until
> now... so, obviously the psqlODBC should be free'ing the memory it
> used for that tuple but instead when i see the Task Manager in windows
> i see how the memory is going down until it gets to zero...
>
> so this should be a memory leak, no? how can i trace it in the psqlODBC?

Could you please try the drivers on testing for 8.4.0201 at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message noreply 2010-05-21 03:20:02 [ psqlodbc-Bugs-1010827 ] ODBC driver not parsing comment correctly
Previous Message B. Nicholson 2010-05-20 21:45:14 Re: FD_SETSIZE with large #s of files/ports in use