On Mon, 2005-03-14 at 12:43 +0000, Richard Huxton wrote: > Take 30 minutes to read through the article below. It covers the basics > of how to manage your configuration settings. > http://www.powerpostgresql.com/PerfList >
That's an informative article. I was hoping, however, that it would have a few details about the effects of the statistics settings on performance. Which statistics options affect the planner? Do they potentially affect autovacuum? Also, a 32-bit machine can only hold so much RAM. If I'm correct, there are ways to address more memory than that on a 32 bit machine, but I wonder at what cost? In other words, is it a good idea to address more than 4GB on a 32 bit machine? If not, is it a reasonable choice to invest in 64 bit if you want >4GB of RAM? Or are you better off just spending the money on RAID and staying at 4GB? Regards, Jeff Davis PS: A minor typo in "Disk and WAL" -> "checkpoint_segments": s/Depening/Depending/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings