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 18:55:01
Message-ID: 1086980100.2539.187.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 2004-06-11 at 14:40, Merlin Moncure wrote:
> I am batch inserting insert statements into a database with fsync = on.
> My single disk system is on a 10k drive...even though I am inside a
> transaction there is at least 1 file sync per row insert.

Which filesystem?

PostgreSQL isn't issuing the sync except at commit of a transaction, but
some filesystems do wacky things if you ask them too.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2004-06-11 19:04:03 Re: in-transaction insert performance in 7.5devel
Previous Message Merlin Moncure 2004-06-11 18:40:00 in-transaction insert performance in 7.5devel