Bugs item #1000619, was opened at 2006-04-25 13:43
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000619&group_id=1000125
Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Possible memory leaks during execution of INSERT and UPDATE statements.
Initial Comment:
I will use unicode PostgreSQL database version 8.0 on linux within the client application on W2K which use PostgreSQL
Unicodedriver version 08.01.0200 (default settings).
Client application use DTL (www.dtemplatelib.sourceforge.net) for SQL operations.
What I have found when application perfroms only SELECT statements merory usage is stable. However when I add INSERT or
UPDATEstatements the memory usage have been slowly increasing during all program execution. I have made the same tests
usingthe MSSQL database and they show stable memory usage.
This convinces me that the most possible place of memory leaks is psqlODBC driver.
The C++ code below show how I use DTL for make insertion
DBView<LoggingRow> view("event");
// build an inserter for the view
DBView<LoggingRow>::insert_iterator loggingInserter = view;
LoggingRow loggingRow;
loggingRow.SetPersonID(personID);
loggingRow.SetStreamID(streamID);
loggingRow.SetLogEvent((int)logEvent);
loggingRow.SetIP(ip);
loggingRow.SetServerName(ServerName);
loggingRow.SetSecondsFromStart(secondsFromStart);
*loggingInserter = loggingRow;
loggingInserter++;
Commit();
This code generate next INSERT statement:
PREPARE "_PLAN00DC7D88"(int4, int4, int4, int4, varchar, varchar) as INSERT INTO EVENT (PERSON_ID, SECONDSFROMSTART,
STREAM_ID,EVENTTYPE_ID, IPADDRESS, SERVERNAME) VALUES (($1), ($2), ($3), ($4), ($5), ($6));EXECUTE
"_PLAN00DC7D88"(100,100,100,5,'0.0.0.0','testserver')
Making 5000 simple INSERTS (console application just call the method which make insert 5000 times) into database
increasesmemory usage of console application by more than 800Kb. The statistic below shows example of memory usage by
consoleapplication (I used "Private Bytes" counter in perfom).
16:25:11.872","3993600"
16:25:12.872","4009984"
16:25:13.872","4030464"
16:25:14.872","4050944"
16:25:15.872","4075520"
16:25:16.872","4096000"
16:25:17.872","4112384"
16:25:18.872","4132864"
16:25:19.872","4153344"
16:25:20.872","4173824"
16:25:21.872","4198400"
16:25:22.872","4218880"
----------------------------------------------------------------------
>Comment By: Dave Page (dpage)
Date: 2006-05-14 09:27
Message:
No response
----------------------------------------------------------------------
Comment By: Dave Page (dpage)
Date: 2006-04-28 09:11
Message:
Please test version 08.02.0002 (available from http://pgfoundry.org/frs/?group_id=1000125) and report whether or not
theproblem still exists.
----------------------------------------------------------------------
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000619&group_id=1000125