From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Katie Ward <kward(at)peerdirect(dot)com> |
Subject: | Re: Win32 Powerfail testing - results |
Date: | 2003-02-03 22:29:51 |
Message-ID: | 1044311391.1811.14.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Dave Page kirjutas E, 03.02.2003 kell 18:51:
> Well the results are finally in. Hopefully we can concentrate on putting
> them right, rather than having a round of "told you so's" :-)
>
> I modified the test program slightly to improve the consistency checks.
> The updated version is attached.
>
> Regards, Dave.
>
> System
> ======
>
> Gigabyte GA-6VTXD Motherboard
> Dual 1GHz PIII Processors
> 1Gb Non-ECC RAM
> Fujitsu MPG3240AH IDE Disk Drive
>
> Enhanced IDE Performance disabled in the BIOS.
>
> Test
> ====
>
> Test program run from a seperate machine.
> 20 Tests per OS.
> Powerfail randomly applied.
Your hardware should also be able to run Postgres on BeOS
http://www.bebits.com/app/2752
Being the only non-unix "port" before/besides win32, it could be an
interesting excercise.
You should be able to get and installable BeOS itself from SourceForge
http://sourceforge.net/projects/crux/
> Windows 2000 Testing
> ====================
Is this NTFS ?
Any possibility of trying the same tests with SCSI disks ?
> Write back cache on IDE disk disabled.
> Clean installation of Windows 2000 Server with Service Pack 3
>
> Run | Errors Detected
> =============================================================
> 01 | None
> 02 | None
> 03 | None
> 04 | None
> 05 | None
> 06 | None
> 07 | COUNT CHECK - Duplicate or missing rows detected (10262)!!
> 08 | None
> 09 | DISTINCT CHECK - Duplicate or missing rows detected (9893)!!
I remember having problems with UNIQUE columns having duplicate values a
few versions back on Linux-ext2-IDE. Could this be the same problem or
must it be something completely different ?
> | COUNT CHECK - Duplicate or missing rows detected (9893)!!
> 10 | None
> 11 | None
> 12 | None
> 13 | None
> 14 | COUNT CHECK - Duplicate or missing rows detected (10024)!!
> 15 | None
> 16 | None
> 17 | None
> 18 | None
> 19 | None
> 20 | None
>
> Linux Testing
> =============
>
> Clean installation of Slackware Linux 8.1 on ext3
> Kernel 2.4.18
>
> Run | Errors Detected
> =============================================================
> 01 | None
> ...
> 20 | None
BTW, are the tests portable enough to run also on MSSQL, Oracle and DB2
?
I know that you can't publish exact results, but perhaps something like
the GreatBridge results - the one that runs only on Win32 did so-and-so,
the one that has 'i' at the end of version number this, and the one
whose name consists of two letters and a number did that ?
--
Hannu Krosing <hannu(at)tm(dot)ee>
From | Date | Subject | |
---|---|---|---|
Next Message | wade | 2003-02-03 22:34:20 | Re: POSIX regex performance bug in 7.3 Vs. 7.2 |
Previous Message | Dave Page | 2003-02-03 22:23:46 | Re: Win32 Powerfail testing - results |