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 might

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. Yik

Re: [PERFORM] Linux memory zone reclaim

2012-07-30 Thread Scott Marlowe
On Mon, Jul 30, 2012 at 10:43 AM, Kevin Grittner 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 "far" a core may n

Re: [PERFORM] Linux memory zone reclaim

2012-07-30 Thread Kevin Grittner
Greg Smith 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 Linux version: Linux