Vlad <marchenko@xxxxxxxxx> writes: > I'm looking for some help in regards to letting Posresql use more > memory. 8.0 can't go past 2Gb of shared memory, and there is really no reason to try because its performance will get worse not better with more than about 50000 shared buffers. 8.1 will relax the 2Gb limit, but it's still far from clear that there's any point in it. The conventional wisdom is that you should leave most of memory free for kernel disk cache, not try to eat it all in shared buffers. I haven't seen any evidence that that's changed in 8.1. It might possibly make sense to use several Gb of shared buffers in a machine with 16Gb or more of RAM, but not in one with only 4Gb RAM. BTW, where did you get the idea that it was sensible to set work_mem higher than maintenance_work_mem? That's just nuts. See the pgsql-performance archives for past discussions of this topic. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
