Re: [HACKERS] Load distributed checkpoint

2006-12-25 Thread Takayuki Tsunakawa
From: "Bruce Momjian" <[EMAIL PROTECTED]> > On an idle system, would someone dirty a large file, and watch the disk > I/O to see how long it takes for the I/O to complete to disk? I ran "dd if=/dev/zero of= bs=8k count=`expr 1048576 / 8`, that is, writing 1GB file with 8KB write()'s. It took abou

Re: [HACKERS] Load distributed checkpoint

2006-12-25 Thread Takayuki Tsunakawa
Hello, Inaam-san, > There are four IO schedulers in Linux. Anticipatory, CFQ (default), deadline, and noop. For typical OLTP type loads generally deadline is recommended. If you are constrained on CPU and you have a good controller then its better to use noop. > Deadline attempts to merge requests

[HACKERS] Windows installer and dlls

2006-12-25 Thread Knut P. Lehre
Installing postgresql 8.2.0 on Windows XP Pro SP2 using the msi installer dated 2006-12-04, with libeay32.dll and ssleay32.dll (both dated 2005-07-06) (and libiconv-2.dll, libintl-2.dll, and libpq.dll) from a previous installation (of version 8.0.5) already present in c:\windows\system32. These