Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.cxlog.c)

2000-11-17 Thread Bruce Momjian
sleep(3) should conform to POSIX specification, if anyone has the reference they can check it to see what the effect of sleep(0) should be. Yes, but Posix also specifies sched_yield() which rather explicitly allows a process to yield its timeslice. No idea how well that is

Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.cxlog.c)

2000-11-17 Thread Bruce Momjian
* Bruce Momjian [EMAIL PROTECTED] [001117 11:23]: sleep(3) should conform to POSIX specification, if anyone has the reference they can check it to see what the effect of sleep(0) should be. Yes, but Posix also specifies sched_yield() which rather explicitly allows a

Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.cxlog.c)

2000-11-16 Thread Bruce Momjian
* Bruce Momjian [EMAIL PROTECTED] [001116 14:02]: This sounds like an interesting approach, yes. Question: Is sleep(0) guaranteed to at least give up control? The way I read my UnixWare 7's man page, it might not, since alarm(0) just cancels the alarm... Well, it certainly

Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.cxlog.c)

2000-11-15 Thread Bruce Momjian
[ Charset ISO-8859-1 unsupported, converting... ] Earlier, Vadim was talking about arranging to share fsyncs of the WAL log file across transactions (after writing your commit record to the log, sleep a few milliseconds to see if anyone else fsyncs before you do; if not, issue the fsync

Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.cxlog.c)

2000-11-11 Thread Bruce Momjian
Bruce Momjian [EMAIL PROTECTED] writes: Not really, I thought an ack on a commit would mean that the data is actually in stable storage, breaking that would be pretty bad no? The default is to sync on commit, but we need to give people options of several seconds delay for performance

Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.cxlog.c)

2000-11-11 Thread Bruce Momjian
Bruce Momjian [EMAIL PROTECTED] writes: I have to agree with Alfred here: this does not sound like a feature, it sounds like a horrid hack. You're giving up *all* consistency guarantees for a performance gain that is really going to be pretty minimal in the WAL context. It does not

Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.cxlog.c)

2000-11-11 Thread Bruce Momjian
Bruce Momjian [EMAIL PROTECTED] writes: I have to agree with Alfred here: this does not sound like a feature, it sounds like a horrid hack. You're giving up *all* consistency guarantees for a performance gain that is really going to be pretty minimal in the WAL context. It does not

Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.cxlog.c)

2000-11-10 Thread Bruce Momjian
* Tatsuo Ishii [EMAIL PROTECTED] [001110 18:42] wrote: Yes, though we can change this. We also can implement now feature that Bruce wanted so long and so much -:) - fsync log not on each commit but each ~ 5sec, if losing some recent commits is acceptable. Sounds great.