Skip site navigation (1) Skip section navigation (2)

memory leak in psqlodb 08.04.0200

From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: memory leak in psqlodb 08.04.0200
Date: 2010-05-17 02:28:35
Message-ID: AANLkTinmZuzJEtYOPpVYx71yYFo83xS9ZTeyKOic4qFA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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

Responses

pgsql-odbc by date

Next:From: Richard BroersmaDate: 2010-05-17 14:41:48
Subject: Re: ADO - adSchemaColumns doesn't seem to work.
Previous:From: Phil BrierleyDate: 2010-05-16 19:45:46
Subject: ADO - adSchemaColumns doesn't seem to work.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group