Skip site navigation (1) Skip section navigation (2)

Maximum transaction rate

From: Jack Orenstein <jack(dot)orenstein(at)hds(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Maximum transaction rate
Date: 2009-03-06 16:55:17
Message-ID: 49B15575.2050909@hds.com (view raw or flat)
Thread:
Lists: pgsql-general
I'm using postgresql 8.3.6 through JDBC, and trying to measure the maximum 
transaction rate on a given Linux box. I wrote a test program that:

- Creates a table with two int columns and no indexes,

- loads the table through a configurable number of threads, with each
   transaction writing one row and then committing, (auto commit is
   false), and

- reports transactions/sec.

The postgres configuration regarding syncing is standard: fsync = on, 
synchronous_commit = on, wal_sync_method = fsync. My linux kernel is 
2.6.27.19-78.2.30.fc9.i686.

The transaction rates I'm getting seem way too high: 2800-2900 with one thread, 
5000-7000 with ten threads. I'm guessing that writes aren't really reaching the 
disk. Can someone suggest how to figure out where, below postgres, someone is 
lying about writes reaching the disk?

Jack

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2009-03-06 17:07:29
Subject: Re: Installing a module for PostgreSQL
Previous:From: Scot KreienkampDate: 2009-03-06 16:23:45
Subject: Re: Postgres with phpScheduleIt

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group