On Wed, Jul 12, 2006 at 10:16:40 -0600, "Koth, Christian (DWBI)" <[EMAIL PROTECTED]> wrote: > > I have noticed a strange performance behaviour using a commit statement on > two different machines. On one of the machines the commit is many times > faster than on the other machine which has faster hardware. Server and client > are running always on the same machine. > > Server version (same on both machines): PostgreSQL 8.1.3. (same binaries as > well) > > PC1: > ---- > IDE-HDD (approx. 50 MB/s rw), fs: ext3 > > PC2: > ---- > SCSI-HDD (approx. 65 MB/s rw), fs: ext3 > > Both installations of the database have the same configuration, different > from default are only the following settings on both machines: > > pgbench gives me the following results: > PC1: > ---- > tps = 293.625393 (excluding connections establishing) > > PC2: > ---- > tps = 46.519634 (excluding connections establishing)
Have you checked to see if the ide drive is lying about having written the data to the platters? ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
