Re: CommitDelay performance improvement

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Vadim Mikheev <vadim4o(at)email(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: CommitDelay performance improvement
Date: 2001-02-23 20:05:27
Message-ID: 200102232005.PAA22767@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Is there significant time between entry of CommitTransaction() and the
> > fsync()? Maybe not.
>
> I doubt it. No I/O anymore, anyway, unless the commit record happens to
> overrun an xlog block boundary.

That's what I was afraid of. Since we don't write the dirty blocks to
the kernel anymore, we don't really have much happening before someone
says they are about to commit. In the old days, we were write()'ing
those buffers, and we had some delay and kernel calls in there.

Guess that idea is dead.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-02-23 20:19:28 Re: beta5 packages ...
Previous Message Tom Lane 2001-02-23 19:55:27 Re: CommitDelay performance improvement