RE: [HACKERS] TODO item - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject RE: [HACKERS] TODO item
Date
Msg-id NDBBIJLOILGIKBGDINDFMEKPCCAA.Inoue@tpf.co.jp
Whole thread Raw
In response to Re: [HACKERS] TODO item  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
> -----Original Message-----
> From: owner-pgsql-hackers@postgresql.org
> [mailto:owner-pgsql-hackers@postgresql.org]On Behalf Of Tatsuo Ishii
>
> > > In the TODO file:
> > >
> > > * -Allow transaction commits with rollback with no-fsync
> performance [fsync](Vadim)
> > >
> > > Has this been done in current? I see almost no performance
> > > improvement on copying data into a table.
> >
> > TODO updated.  That was part of MVCC which originally was supposed to be
> > in 7.0.
>
> Thanks.
>
> BTW, I have worked a little bit on this item. The idea is pretty
> simple. Instead of doing a real fsync() in pg_fsync(), just marking it
> so that we remember to do fsync() at the commit time. Following

This seems not good,unfortunately.
Note that the backend which calls pg_fsync() for a relation file may
be different from the backend which updated shared buffers of the file.
The former backend wouldn't necessarily be committed when the
latter backend is committed.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] TODO item
Next
From: Michael Meskes
Date:
Subject: Re: [HACKERS] Two backends at the same time