RE: [HACKERS] Problems w/ LO - Mailing list pgsql-hackers

From Vince Vielhaber
Subject RE: [HACKERS] Problems w/ LO
Date
Msg-id XFMail.990527154410.vev@michvhf.com
Whole thread Raw
In response to Problems w/ LO  ("Brandon Palmer" <bap@scl.cwru.edu>)
List pgsql-hackers
On 27-May-99 Brandon Palmer wrote:
> I am having some problems w/ LO in postgres 6.5.snapshot  (date marked
> 5/27).  Here is the problem:
> 
> I am doing a program that will search through ~250M of text in LO
> format.  The search function seems to be running out of ram as I get a
> 'NOTICE:  ShmemAlloc: out of memory' error after the program runs for a
> bit.  From running 'free',  I can see that I am not using any memory in
> my swap space yet,  so it does not really seem to be running out of
> memory.  Postmaster does constantly grow even though I am not
> generating any information that should make it grow at all.  When I
> have commented out the lo_open and lo_close function calls,  everything
> is ok so I am guessing that there is some kind of a leak in the lo_open
> and lo_close functions if not in the back end in postmaster.  Come take
> a look at the code if you please:
> 
> http://x.cwru.edu/~bap/search_4.c

What are you running it on?   What kind of limits do you have in your
shell (man limits in FreeBSD).

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH   email: vev@michvhf.com   flame-mail: /dev/null      # include <std/disclaimers.h>
       TEAM-OS2       Online Campground Directory    http://www.camping-usa.com      Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================




pgsql-hackers by date:

Previous
From: "Brandon Palmer"
Date:
Subject: Problems w/ LO
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Open 6.5 items