Tom Lane wrote: > Raphael Bauduin <[EMAIL PROTECTED]> writes: > > At some times, it seems to hang: it doesn't insert any rows for more > > than 10 seconds. At that time, the postmaster process takes 0%. Why is > > that? > > At a guess, you're seeing the syncer daemon flushing a lot of dirty > kernel disk buffers out to disk, and thereby monopolizing disk I/O. > I haven't experimented too much with Linux, but on HPUX it's not > difficult for a sync() call to bring the system to its knees for many > seconds, if you've got application programs that have written a whole > lot of pages since the last sync.
Some BSD's implement trickle sync, for this very reason. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
