Re: [HACKERS] fsynch of pg_log write..

From: Zeugswetter Andreas IZ5 <Andreas(dot)Zeugswetter(at)telecom(dot)at>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] fsynch of pg_log write..
Date: 1999-06-25 08:18:57
Message-ID: 219F68D65015D011A8E000006F8590C60267B3B1@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Vadim wrote:
> Right way is just set some flag in WriteBuffer()/WriteNoReleaseBuffer()
> and don't do
>
> FlushBufferPool
> TransactionIdCommit
> FlushBufferPool
>
> at all when this flag is not setted.
>
While this is even much better for select only transactions
it will still do the second flush for writers.
This flush is not needed for those, that are only interested
in consistency, and don't care if the last transaction before
system/backend crash is lost.
It can actually really only be the very last transaction reported
ok to any client, that is rolled back, since all other xactions
will be flushed by this same first FlushBufferPool
(since BufferSync currently flushes all dirty Pages).
So IMHO a switch to avoid the second FlushBufferPool
would still be useful, even with this suggested fix.

Andreas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message rafael 1999-06-25 11:22:30 postgres
Previous Message Wayne Piekarski 1999-06-25 06:52:36 Re: trouble creating log table with rules