Re: performance of insert/delete/update - Mailing list pgsql-performance

From Josh Berkus
Subject Re: performance of insert/delete/update
Date
Msg-id 200211231231.50102.josh@agliodbs.com
Whole thread Raw
In response to Re: performance of insert/delete/update  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: performance of insert/delete/update
List pgsql-performance
Tom,

> On my machine I see a sizable difference (more than 2x) in the rate at
> which simple INSERT statements are processed as separate transactions
> and as large batches --- if I have fsync on.  With fsync off, nearly no
> difference.

I'm using fdatasych, which *does* perform faster than fsych on my system.
Could this make the difference?

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: performance of insert/delete/update
Next
From: Tom Lane
Date:
Subject: Re: performance of insert/delete/update