Re: in-transaction insert performance in 7.5devel

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: in-transaction insert performance in 7.5devel
Date: 2004-06-11 19:27:01
Message-ID: 1086982020.2539.189.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> As I understand it, sync() is never called anymore. mdsync() hits the
> all the files 1 by 1 with an fsync. My understanding of the commit
> process is that 30 tps is quite reasonable for my hardware.

Sorry. I didn't see the version in the subject and assumed 7.4 on a
Linux machine with excessive journaling enabled.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Litao Wu 2004-06-11 19:35:23 Re: reindex and copy - deadlock?
Previous Message Merlin Moncure 2004-06-11 19:04:03 Re: in-transaction insert performance in 7.5devel