I have been looking for a good reference on tuning performance/memory use/etc, but have had no luck. I have a TON of free memory on my Linux Box - over 100MB. It doesn't appear that Postgres uses this memory when needed - instead it seems to hit the hard disk for each query. Do I have to specify the amount of buffering I want it to use? I see the -B command, but I figured that was more for inserting records. If I have a 100MB table that I want cached in memory, do I need to use 100MB of buffers with the -B switch?? Thanks, Tim Perdue
