On Aug 17, 2005, at 10:11 PM, Jeremiah Jahn wrote:

I just put together a system with 6GB of ram on a 14 disk raid 10 array.
When I run my usual big painful queries, I get very little to know
memory usage. My production box (raid 5 4GB ram) hovers at 3.9GB used
most of the time. the new devel box sits at around 250MB.


Is the system performing fine? Are you touching as much data as the production box?

If the system is performing fine don't worry about it.

work_mem = 2097151              # min 64, size in KB

This is EXTREMELY high. You realize this is the amount of memory that can be used per-sort and per-hash build in a query? You can end up with multiples of this on a single query. If you have some big queries that are run infrequently have them set it manually.

effective_cache_size = 3600000 <-----this is a little out of control, but would it have any real effect?

This doesn't allocate anything - it is a hint to the planner about how much data it can assume is cached.

--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

Reply via email to