Dnia poniedziałek, 21 listopada 2005 11:23, Mario Splivalo napisał: > On Mon, 2005-11-21 at 10:58 +0100, Marcin Giedz wrote: > > Dnia poniedziałek, 21 listopada 2005 10:34, Mario Splivalo napisał: > > > On Sun, 2005-11-20 at 11:53 -0600, Jim C. Nasby wrote: > > > > Two general comments: most people find that Opterons perform much > > > > better than Xeons. With some versions of PostgreSQL, the difference > > > > is over 50%. > > > > > > Could you be more specific on that? Which version of Postgres perform > > > better on Opteron than on Xeon? > > > > Try http://85.128.68.44 - I made some test about Xeon and Opteron > > Cool! :) Could you give specs on processors itself? The clock, cache, > and stuff? Look at this site once again - made some additional info. > > > > RAID5 was not ment to improve performance, but to minimize disaster and > > > downtime when your hard disk dies. We're using RAID5 with postgres. In > > > the last 3 years we changed 5 disks, but the system downtime was zero > > > minutes. > > > > I'm ready enough to put some tests about different RAID's for Postgresql > > - but I will soon. However almost all people I know preffer RAID10 for > > database like PGSQL. > > What do you mean when you say RAID10? Raid 1+0, or striped raid 5? Raid 1+0. > > Mike ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings