X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6C9D611F6780 for ; Tue, 4 Apr 2006 15:15:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33733-10 for ; Tue, 4 Apr 2006 15:15:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from krusty.pcisys.net (krusty.pcisys.net [216.229.32.178]) by postgresql.org (Postfix) with ESMTP id C6ADC11F6708 for ; Tue, 4 Apr 2006 15:14:57 -0300 (ADT) Received: from [192.168.0.101] (dsl-206-53-31-65.cos.pcisys.net [206.53.31.65]) by krusty.pcisys.net (8.13.3/8.13.3) with ESMTP id k34IElMO009796 for ; Tue, 4 Apr 2006 12:14:47 -0600 (MDT) User-Agent: Microsoft-Entourage/10.1.4.030702.0 Date: Tue, 04 Apr 2006 12:14:52 -0700 Subject: Memory Usage and libpq From: Keary Suska To: Postgres-Interfaces Message-ID: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.115 required=5 tests=[AWL=0.115] X-Spam-Score: 0.115 X-Spam-Level: X-Archive-Number: 200604/1 X-Sequence-Number: 6092 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? Thanks, Keary Suska (719) 473-6431 (719) 440-9952 (cell)