RE: [HACKERS] Problems w/ LO
От | Vince Vielhaber |
---|---|
Тема | RE: [HACKERS] Problems w/ LO |
Дата | |
Msg-id | XFMail.990527154410.vev@michvhf.com обсуждение исходный текст |
Ответ на | Problems w/ LO ("Brandon Palmer" <bap@scl.cwru.edu>) |
Список | 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 по дате отправления: