| From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
|---|---|
| To: | Brandon Palmer <bap(at)scl(dot)cwru(dot)edu> |
| Cc: | "hackers(at)postgreSQL(dot)org" <hackers(at)postgreSQL(dot)org> |
| Subject: | RE: [HACKERS] Problems w/ LO |
| Date: | 1999-05-27 19:44:10 |
| Message-ID: | XFMail.990527154410.vev@michvhf.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)michvhf(dot)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
==========================================================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-05-27 20:39:11 | Re: [HACKERS] Open 6.5 items |
| Previous Message | Brandon Palmer | 1999-05-27 19:25:36 | Problems w/ LO |