Re: Memory exhausted in AllocSetReAlloc

> That's it, trying to make postgres use more memory I cranked up SORT_MEM
> to a much too high value. I just reduced it back to 1024 and it's working
> fine now.
>
> Thanks to the other posters who replied, I found out FreeBSD's default
> kernel limits the data segment size to 128M, so I raised that as well.
>
> I certainly didn't understand SORT_MEM's semantics. Any pointers, hints
> on how to tune postgres to make best use of all the memory I've got
> would be appreciated. My largest table is going to have ~ 200 million
> rows. The docs are a little terse on how to tune for that kind of volume.

There is a performance paper I wrote on techdocs site:

    http://techdocs.postgresql.org

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026