Re: [PERFORM] Linux memory zone reclaim

2012-07-30 Thread Kevin Grittner
Greg Smith g...@2ndquadrant.com wrote: You can tell if this is turned on like this: echo /proc/sys/vm/zone_reclaim_mode As a data point, the benchmarks I did for some of the 9.2 scalability features does not appear to have this turned on: # cat /proc/sys/vm/zone_reclaim_mode 0 Our

Re: [PERFORM] Linux memory zone reclaim

2012-07-30 Thread Scott Marlowe
On Mon, Jul 30, 2012 at 10:43 AM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: node distances: node 0 1 2 3 0: 10 11 11 11 1: 11 10 11 11 2: 11 11 10 11 3: 11 11 11 10 When considering a hardware purchase, it might be wise to pay close attention to how

Re: [PERFORM] Linux memory zone reclaim

2012-07-30 Thread Bruce Momjian
node distances: node 0 1 2 3 0: 10 11 11 11 1: 11 10 11 11 2: 11 11 10 11 3: 11 11 11 10 When considering a hardware purchase, it might be wise to pay close attention to how far a core may need to go to get to the most distant RAM. Yikes, my server

Re: [PERFORM] Postgres 9.1.4 - high stats collector IO usage

2012-07-30 Thread Mark Kirkwood
On 29/07/12 05:08, David Barton wrote: Thanks so much, Tom. That did the job. I increased it to every 15 minutes and it has dropped substantially even though the pgstat.stat file is over 1 MB again. I'd be a little concerned that having autovacuum tuned down to run so infrequently