Postgres Pro
Downloads
Home   >   mailing lists

Re: in-transaction insert performance in 7.5devel - Mailing list pgsql-performance

From Rod Taylor
Subject Re: in-transaction insert performance in 7.5devel
Date
Msg-id 1086982020.2539.189.camel@jester
Whole thread Raw
In response to Re: in-transaction insert performance in 7.5devel  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List pgsql-performance
Tree view 
> 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.

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: in-transaction insert performance in 7.5devel
Next
From: Litao Wu
Date:
Subject: Re: reindex and copy - deadlock?