[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

Re: [PERFORM] Checkpoint distribution

2014-04-14 Thread Borodin Vladimir
14 апр. 2014 г., в 19:11, Jeff Janes написал(а): > On Mon, Apr 14, 2014 at 2:46 AM, Borodin Vladimir wrote: > Hi all. > > I’m running PostgreSQL 9.3.4 and doing stress test of the database with > writing only load. The test plan does 1000 transactions per second (each of >