"Gordon P. Oliver" <gordulat(at)pacbel(dot)net> writes:
> I have a problem that generates the out of memory error above in a
> consistent manner. It doesn't seem to be covered in the faq's. Note that
> this same code does _not_ fail in 7.2.1-5, but please don't ask me to
> upgrade, it is a production server :-)
> Version:
> postgresql-7.0.3-8 (RedHat)
Sorry, but you need to upgrade. 7.0.* and before leak memory within
large queries. This isn't a FAQ anymore because it stopped being
interesting more than a year ago...
regards, tom lane