Re: [PERFORM] Stats collector constant I/O

2014-05-15 Thread Jeff Janes
On May 14, 2014 9:19 PM, Craig James cja...@emolecules.com wrote: Day and night, the postgres stats collector process runs at about 20 MB/sec output. vmstat shows this: $ vmstat 2 procs ---memory-- ---swap-- -io -system-- cpu r b swpd free buff cache

Re: [PERFORM] Stats collector constant I/O

2014-05-15 Thread Pavel Stehule
Hello we had similar issue - you can try to move statfile to ramdisc http://serverfault.com/questions/495057/too-much-i-o-generated-by-postgres-stats-collector-process Regards Pavel Stehule 2014-05-15 6:18 GMT+02:00 Craig James cja...@emolecules.com: Day and night, the postgres stats

Re: [PERFORM] Stats collector constant I/O

2014-05-15 Thread Tomas Vondra
On 15.5.2014 06:18, Craig James wrote: Day and night, the postgres stats collector process runs at about 20 MB/sec output. vmstat shows this: $ vmstat 2 procs ---memory-- ---swap-- -io -system-- cpu r b swpd free buff cache si sobibo