> 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