Hello Alfred, Friday, March 16, 2001, 3:21:09 PM, you wrote: AP> * Xu Yifeng <[EMAIL PROTECTED]> [010315 22:25] wrote: >> >> Could anyone consider fork a syncer process to sync data to disk ? >> build a shared sync queue, when a daemon process want to do sync after >> write() is called, just put a sync request to the queue. this can release >> process from blocked on writing as soon as possible. multipile sync >> request for one file can be merged when the request is been inserting to >> the queue. AP> I suggested this about a year ago. :) AP> The problem is that you need that process to potentially open and close AP> many files over and over. AP> I still think it's somewhat of a good idea. I am not a DBMS guru. couldn't the syncer process cache opened files? is there any problem I didn't consider ? -- Best regards, Xu Yifeng ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
- Re: [HACKERS] Allowing WAL fsync to be don... Tom Lane
- [HACKERS] Re: Allowing WAL fsync to be... Thomas Lockhart
- Re: [HACKERS] Allowing WAL fsync to be don... Bruce Momjian
- Re: [HACKERS] Allowing WAL fsync to be done via O_... Bruce Momjian
- RE: [HACKERS] Allowing WAL fsync to be done via O_SYNC Mikheev, Vadim
- Re: [HACKERS] Allowing WAL fsync to be done via O_... Alfred Perlstein
- Re: [HACKERS] Allowing WAL fsync to be done vi... Tom Lane
- Re: [HACKERS] Allowing WAL fsync to be don... Alfred Perlstein
- Re[2]: [HACKERS] Allowing WAL fsync to be ... Xu Yifeng
- Re: Re[2]: [HACKERS] Allowing WAL fsyn... Alfred Perlstein
- Re: Re[4]: [HACKERS] Allowing WAL... Xu Yifeng
- Re: Re[4]: [HACKERS] Allowing... Alfred Perlstein
- Re: Re[4]: [HACKERS] Allowing... Tom Lane
- Re: Re[4]: [HACKERS] Allowing... Alfred Perlstein
- Re: Re[4]: [HACKERS] Allowing... Tom Lane
- Re: Re[4]: [HACKERS] Allowing... The Hermit Hacker
- Re: Re[4]: [HACKERS] Allowing... Larry Rosenman
- Re: Re[4]: [HACKERS] Allowing... Tom Lane
- Re: Re[4]: [HACKERS] Allowing... Bruce Momjian
- Re: Re[4]: [HACKERS] Allowing... Alfred Perlstein
- Re: [HACKERS] Allowing WAL fs... William K. Volkman