"Shuo Liu" <delphet@xxxxxxxxxx> writes: >> Whoa ... that is a whole lot more data than I'm used to seeing in >> TopMemoryContext. How many stats dump lines are there exactly (from >> here to the crash report)? > OK, I didn't know that was a surprise. There are about 600 stats dump lines > in between. Well, my suspicion was correct: there were boatloads of memory contexts, but we weren't seeing all of them. The answer is twofold: 1. Your function is opening a cursor (maybe more than one, I didn't read too carefully) on each iteration, and not closing it. This results in a sizable amount of memory being eaten --- it looks like a couple hundred K per cursor on my machine. Eventually you run out of memory. 2. PostGIS has a bug that causes a guaranteed crash once you run out of memory, if you've been using transform(), because it sets up a memory context that has no stats() method. That's why the context stats printout failed partway through --- it crashed as soon as it came to one of the PostGIS contexts. I've complained to the PostGIS folk about the latter, and hopefully they'll fix it in their next release. Meanwhile, you need to be more careful about closing cursors when you're done with them. regards, tom lane
