Re: Commit delay (was Re: beta5 packages)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Commit delay (was Re: beta5 packages)
Date: 2001-02-23 22:23:16
Message-ID: 915.982966996@sss.pgh.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:
> OK, clearly your looking at the bit is better than what we have now, so
> how about committing something that looks at the bit, but leave the
> default at zero. Then, let people test zero and non-zero delays and
> let's see what they find. That seems safe because we aren't enabling
> the problematic delay by default, at least until we find it is a help in
> most cases.

What I think I will do is write the code and try some pgbench tests with
scalefactor > 1. If that looks promising, I'll post or commit the code
and ask people to do more tests. We can hold off changing the default
delay back to nonzero until we have more data...

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-02-23 22:26:53 Re: CommitDelay performance improvement
Previous Message Vince Vielhaber 2001-02-23 22:23:01 Re: regression test form