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
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 |