From: | Keary Suska <hierophant(at)pcisys(dot)net> |
---|---|
To: | Postgres-Interfaces <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | Re: Memory Usage and libpq |
Date: | 2006-04-04 20:24:38 |
Message-ID: | C0582416.27D99%hierophant@pcisys.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
on 4/4/06 11:23 AM, terry(at)esc1(dot)com purportedly said:
>
> On Tuesday 04 April 2006 03:14 pm, Keary Suska saith:
>> I am investigating a memory usage issue and I noticed something with libpq.
>> It appears that libpq doesn't actually free memory allocated to store
>> results, even after PQclear() is called. In a debug program I can inspect
>> the buffer so I know it exists. I haven't verified whether the buffer is
>> resized with subsequent calls, but when dealing with large result sets it
>> creates a significant memory overhead.
>>
>> Am I on to something here or do I need to keep looking? If so, is there any
>> way that I can force libpq to free or in some way drastically reduce this
>> biffer?
>
> I may be wrong about this, but just because you can access the memory after
> the call to PQclear, doesn't mean that the memory wasn't freed; it just means
> it hasn't been reused yet. The address still exists and freeing the memory
> doesn't "clear" it out.
It almost goes without saying, but it does encourage me to question whether
my debug program is showing deallocated memory, or further, if for some
reason the system/runtime isn't giving the memory back to the kernel
(something I am pursuing elsewhere). I will run a test of my own and see if
my debug program is showing deallocated memory.
Thanks,
Keary Suska
Esoteritech, Inc.
"Demystifying technology for your home or business"
From | Date | Subject | |
---|---|---|---|
Next Message | Keary Suska | 2006-04-04 20:41:20 | Re: PQconnectdb et.all. |
Previous Message | Tom Lane | 2006-04-04 20:06:06 | Re: Memory Usage and libpq |