At 02:13 PM 11/16/00 -0500, Bruce Momjian wrote: >> I think the default should probably be no delay, and the documentation >> on enabling this needs to be clear and obvious (i.e. hard to miss). > >I just talked to Tom Lane about this. I think a sleep(0) just before >the flush would be the best. It would reliquish the cpu slice if >another process is ready to run. If no other backend is running, it >probably just returns. If there is another one, it gives it a chance to >complete. On return from sleep(0), it can check if it still needs to >flush. This would tend to bunch up flushers so they flush only once, >while not delaying cases where only one backend is running. This sounds like an interesting approach, yes. - Don Baccus, Portland OR <[EMAIL PROTECTED]> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert Service and other goodies at http://donb.photo.net.
- RE: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/t... Mikheev, Vadim
- Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/acc... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend... Vadim Mikheev
- Re: [HACKERS] RE: [COMMITTERS] pgsql/src/bac... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTERS] pgsql/src... Alfred Perlstein
- Re: [HACKERS] RE: [COMMITTERS] pgsq... Don Baccus
- Re: [HACKERS] RE: [COMMITTERS] ... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTE... Don Baccus
- Re: [HACKERS] RE: [COMMITTE... Larry Rosenman
- Re: [HACKERS] RE: [COMMITTE... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTE... Larry Rosenman
- Re: [HACKERS] RE: [COMMITTE... Alfred Perlstein
- Re: [HACKERS] RE: [COMMITTE... Tom Samplonius
- Re: [HACKERS] RE: [COMMITTE... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTE... Larry Rosenman
- Re: [HACKERS] RE: [COMMITTE... Bruce Momjian
- Re: [HACKERS] RE: [COMMITTE... Larry Rosenman
- [HACKERS] WAL fsync schedul... Bruce Momjian