I am using Npgsql to connect from a webapplication to a PostgreSQL Database.
When I insert one row into a table (containing a filestream converted to
bytea) the webserver allocates too much RAM for the webserver process
(around 80MB when uploading a 4 MB file) and does not deallocate the RAM
after executing the statement and closing the connection.
I know this is not directly related to PostgreSQL, but maybe someone of you
has already has this behaviour and has some hints for me how to make the
webserver not allocate as much space or at least deallocate the RAM after
finishing the insert statement.
The Npgsql statement that causes this is:
Unfortunately I could not yet get any help in the Npgsql forums, maybe you
can help me out.
I'd be grateful for any help.
pgsql-novice by date
|Next:||From: Ioannis Anagnostopoulos||Date: 2012-01-11 12:11:13|
|Subject: Complex structure storage, better in temp table or array?|
|Previous:||From: Matthew Foster||Date: 2012-01-09 21:03:19|
|Subject: Re: Strategy for doing number-crunching|