Re: [PERFORM] XFS filessystem for Datawarehousing

2006-08-03 Thread Koth, Christian (DWBI)
Milen, XFS, EXT3, JFS For what reason are you planning to use a journaling FS? I think using WAL, fsyncing every transaction and using a journaling FS is tautologous. And if you have problems using EXT2 you can just add the journal later without loosing data. My tests using EXT2 showed a

Re: [PERFORM] Commit slower on faster PC

2006-07-13 Thread Koth, Christian (DWBI)
Hello all, thanks a lot for your help so far. You all where right about the IDE drive is somehow caching the data. See the test results below. I also get different tps values every time I run pgbench on PC1 (between 300 and 80 tps for 100 transactions). I don't think it's a good idea to

[PERFORM] Commit slower on faster PC

2006-07-12 Thread Koth, Christian (DWBI)
Hi, please help me with the following problem: I have noticed a strange performance behaviour using a commit statement on two different machines. On one of the machines the commit is many times faster than on the other machine which has faster hardware. Server and client are running always