Обсуждение: memory leak in psqlodb 08.04.0200
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? -- Jaime Casanova www.2ndQuadrant.com Soporte y capacitación de PostgreSQL
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
On Thu, May 20, 2010 at 10:19 PM, Hiroshi Inoue <inoue@tpf.co.jp> wrote: > Jaime Casanova wrote: >> >> >> 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 > ? > seems like this fix the problem -- Jaime Casanova www.2ndQuadrant.com Soporte y capacitación de PostgreSQL
On Sat, May 22, 2010 at 7:35 AM, Jaime Casanova <jaime@2ndquadrant.com> wrote: > On Thu, May 20, 2010 at 10:19 PM, Hiroshi Inoue <inoue@tpf.co.jp> wrote: >> Jaime Casanova wrote: >>> >>> >>> 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 >> ? >> > > seems like this fix the problem > When will this be released? -- Jaime Casanova www.2ndQuadrant.com Soporte y capacitación de PostgreSQL