Re: [PERFORM] Debugging writing load

2014-07-25 Thread Craig Ringer
On 07/24/2014 10:22 PM, Borodin Vladimir wrote: > Hi all. > > I have a database with quiet heavy writing load (about 20k tps, 5k of > which do writes). And I see lots of writing I/O (I mean amount of data, > not iops) to this database, much more than I expect. My question is how > can I debug what

[PERFORM] Debugging writing load

2014-07-24 Thread Borodin Vladimir
Hi all. I have a database with quiet heavy writing load (about 20k tps, 5k of which do writes). And I see lots of writing I/O (I mean amount of data, not iops) to this database, much more than I expect. My question is how can I debug what for backend processes do lots of writes to the $PGDATA/b