Hi,
postgresql recently ran out of memory on a server here.
It turned out that each query of the form
Rowset<Row> rs = (sql->prepare << "SELECT * FROM table");
hogs a chunk of memory in the connected postgresql server process.
As soon as the session is closed, the memory is freed.
(With a persistent session the memory growth is visible after a few
tens of queries).
Building SOCI with SOCI_PGSQL_NOPREPARE=1 seems to solve the problem.
Observed with postgresql 8.1.10 and 8.3.6 (using soci 2.2.0)
Cheers
Anders
------------------------------------------------------------------------------
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
