Re: performance of insert/delete/update

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Re: performance of insert/delete/update
Date: 2002-11-23 20:31:50
Message-ID: 200211231231.50102.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-11-23 20:41:57 Re: performance of insert/delete/update
Previous Message Tom Lane 2002-11-23 20:20:10 Re: performance of insert/delete/update

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2002-11-23 20:41:57 Re: performance of insert/delete/update
Previous Message Tom Lane 2002-11-23 20:20:10 Re: performance of insert/delete/update