On Mon, 2 Jun 2003, Winelfred G. Pasamba wrote:
> hi guys, > > which would be theoretically faster? > 1) Pentium IV 2.4Ghz, 786MB DDR > 2) Pentium IV 1.6Ghz, 512MB RDRAM > > No queries fill the 512MB of ram. > Postgresql 7.3.2 > Linux version 2.2.25 1. Database servers function much better with more RAM and faster HARD DISKS. If possible: - fill your motherboard to the rafters with memory, Linux will use the extra ram as a disk and buffer cache. - and use faster hard disks, separate controllers (if IDE, then use multiple IDE controllers (promise?)) and configure them for STRIPED operation (RAID 0), so you aggregate your disk I/O - 2.2.25 is ANCIENT. Use the 2.4 kernel (2.4.21pre is the latest) which has much better I/O performance than the 2.2 kernel. - remember, the slowest peripheral in a database system is ALWAYS the disk, so be sure to prioritize that before anything else. > > I currently plugged the 2.4Ghz into the RDRAM motherboard and this is dmesg > > Detected 1794611 kHz processor. > Calibrating delay loop... 3578.26 BogoMIPS > Memory: 516704k/524032k available (1332k kernel code, 420k reserved, 5480k > data, 96k init)h table entries: 65536 (order 7, 512k) > CPU: L1 I cache: 12K, L1 D cache: 8K > CPU: L2 cache: 512K > CPU: Intel(R) Pentium(R) 4 CPU 2.40GHz > > seems like the motherboard's maximum is 1.8Ghz > > thankx for you opinion, > win > -- > Philippine Linux Users' Group (PLUG) Mailing List > [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) > Official Website: http://plug.linux.org.ph > Searchable Archives: http://marc.free.net.ph > . > To leave, go to http://lists.q-linux.com/mailman/listinfo/plug > . > Are you a Linux newbie? To join the newbie list, go to > http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie > > -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
