Re: [PERFORM] Performance pb vs SQLServer.

2005-08-15 Thread Magnus Hagander
[very, very offtopic] Ok. This comparition is just as useless as the other one, because it's comparing oranges with apples (It's funny anyway). I was just choosing an example in which you can see the best of postgresql against 'not so nice' behavior of mssql2000 (no service pack, it's my

Re: [PERFORM] Performance pb vs SQLServer.

2005-08-15 Thread Alvaro Herrera
On Mon, Aug 15, 2005 at 10:25:47AM +0200, Magnus Hagander wrote: SQL 2005 has MVCC (they call it something different, of course, but that's basicallyi what it is) Interesting; do they use an overwriting storage manager like Oracle, or a non-overwriting one like Postgres? -- Alvaro Herrera

Re: [PERFORM] I'm configuraing a new system (Bigish) and need some advice.

2005-08-15 Thread Jeremiah Jahn
7.4 is the pg version BTWgoing to switch to 8 if it's worth it. Ingrate, n.: A man who bites the hand that feeds him, and then complains of indigestion. -- Don't say yes until I finish talking. -- Darryl F. Zanuck -- Don't say yes until I finish talking. --

[PERFORM] choosing RAID level for xlogs

2005-08-15 Thread Anjan Dave
Hi, One simple question. For 125 or more checkpoint segments (checkpoint_timeout is 600 seconds, shared_buffers are at 21760 or 170MB) on a very busy database, what is more suitable, a separate 6 disk RAID5 volume, or a RAID10 volume? Databases will be on separate spindles. Disks are