Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-02-23 22:26:53
Subject: Re: CommitDelay performance improvement
Previous:From: Vince VielhaberDate: 2001-02-23 22:23:01
Subject: Re: regression test form

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group