Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Regression tests on Nintendo Game Cube

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, steil(at)in(dot)tum(dot)de,pgsql-advocacy(at)postgresql(dot)org
Subject: Re: [HACKERS] Regression tests on Nintendo Game Cube
Date: 2004-03-04 20:24:53
Message-ID: 1078431893.22416.182.camel@camel (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackers
Very Cool!  Can we add this to the list of supported platforms?  Also
what do folks think of submitting this as a news blurb to slashdot? 
This seems like some "good feelings" type news that is right up thier
alley.

Robert Treat

On Thu, 2004-03-04 at 02:46, Hans-Jürgen Schönig wrote:
> Folks,
> 
> Today Michael Steil and I have tested PostgreSQL 7.4.1 on Nintendo Game 
> Cubes.
> All regression test (but stats - stats collector was off instead of on) 
> have passed successfully.
> 
> 
> [root(at)192 root]# uname -a
> Linux 192.168.0.47 2.6.3 #20 Wed Mar 3 12:22:07 CET 2004 ppc unknown 
> unknown GNU/Linux
> 
> 
> [root(at)192 root]# cat /proc/cpuinfo
> processor       : 0
> cpu             : 745/755
> revision        : 50.20 (pvr 0008 3214)
> bogomips        : 968.70
> vendor          : IBM
> machine         : Nintendo GameCube
> 
> 
> It is damn hard to compile PostgreSQL on 24 mb ram + 16 mb swap (stolen 
> from my sound buffer provided by Nintendo). gram.c and preproc.c have 
> been compiled on an imac maschine - the rest has been compiled on 
> Michael's Game Cube.
> 
> Compiling and regression testing takes around 3000000000 years (wow, 
> this kind of stuff is damn slow - it is not a good database server *g*).
> 
> Game Cubes are now fully supported by us ;).
> 
> 	Cheers,
> 
> 		Michael and Hans
> 
> 
> ============= starting postmaster                    ==============
> running on port 65432 with pid 24018
> ============== creating database "regression"         ==============
> CREATE DATABASE
> ALTER DATABASE
> ============== dropping regression test user accounts ==============
> ============== installing PL/pgSQL                    ==============
> ============== running regression test queries        ==============
> parallel group (13 tests):  char  int2 name boolean varchar text int8 
> oid int4 float4 float8 bit numeric
>       boolean              ... ok
>       char                 ... ok
>       name                 ... ok
>       varchar              ... ok
>       text                 ... ok
>       int2                 ... ok
>       int4                 ... ok
>       int8                 ... ok
>       oid                  ... ok
>       float4               ... ok
>       float8               ... ok
>       bit                  ... ok
>       numeric              ... ok
> test strings              ... ok
> test numerology           ... ok
> parallel group (20 tests):  point lseg box date circle time path reltime 
> abstime type_sanity timestamptz interval tinterval timestamp timetz 
> comments polygon inet opr_sanity oidjoins
>       point                ... ok
>       lseg                 ... ok
>       box                  ... ok
>       path                 ... ok
>       polygon              ... ok
>       circle               ... ok
>       date                 ... ok
>       time                 ... ok
>       timetz               ... ok
>       timestamp            ... ok
>       timestamptz          ... ok
>       interval             ... ok
>       abstime              ... ok
>       reltime              ... ok
>       tinterval            ... ok
>       inet                 ... ok
>       comments             ... ok
>       oidjoins             ... ok
>       type_sanity          ... ok
>       opr_sanity           ... ok
> test geometry             ... ok
> test horology             ... ok
> test insert               ... ok
> test create_function_1    ... ok
> test create_type          ... ok
> test create_table         ... ok
> test create_function_2    ... ok
> test copy                 ...  ok
> parallel group (7 tests):   create_operator create_aggregate  vacuum 
> inherit triggers constraints create_misc
>       constraints          ... ok
>       triggers             ... ok
>       create_misc          ... ok
>       create_aggregate     ... ok
>       create_operator      ... ok
>       inherit              ... ok
>       vacuum               ... ok
> parallel group (2 tests):   create_view create_index
>       create_index         ... ok
>       create_view          ... ok
> test sanity_check         ...  ok
> test errors               ... ok
> test select               ... ok
> parallel group (17 tests):   select_distinct select_into select_distinct_on
> 
> 
>   select_having case update union random aggregates transactions 
> select_implicit arrays subselect hash_index join portals btree_index
>       select_into          ... ok
>       select_distinct      ... ok
>       select_distinct_on   ... ok
>       select_implicit      ... ok
>       select_having        ... ok
>       subselect            ... ok
>       union                ... ok
>       case                 ... ok
>       join                 ... ok
>       aggregates           ... ok
>       transactions         ... ok
>       random               ... ok
>       portals              ... ok
>       arrays               ... ok
>       btree_index          ... ok
>       hash_index           ... ok
>       update               ... ok
> test privileges           ... ok
> test misc                 ... ok
> parallel group (5 tests):  portals_p2 select_views cluster rules foreign_key
>       select_views         ... ok
>       portals_p2           ... ok
>       rules                ... ok
>       foreign_key          ... ok
>       cluster              ... ok
> parallel group (14 tests):
> 
>   sequence limit polymorphism without_oid truncate copy2 prepare temp 
> rangefuncs conversion domain stats plpgsql alter_table
>       limit                ... ok
>       plpgsql              ... ok
>       copy2                ... ok
>       temp                 ... ok
>       domain               ... ok
>       rangefuncs           ... ok
>       prepare              ... ok
>       without_oid          ... ok
>       conversion           ... ok
>       truncate             ... ok
>       alter_table          ... ok
>       sequence             ... ok
>       polymorphism         ... ok
>       stats                ... FAILED
> ============== shutting down postmaster               ==============
> 
> =======================
>   1 of 93 tests failed.
> =======================
> 
> The differences that caused some tests to fail can be viewed in the
> file `./regression.diffs'.  A copy of the test summary that you see
> above is saved in the file `./regression.out'.
> 
> -- 
> Cybertec Geschwinde u Schoenig
> Schoengrabern 134, A-2020 Hollabrunn, Austria
> Tel: +43/2952/30706 or +43/664/233 90 75
> www.cybertec.at, www.postgresql.at, kernel.cybertec.at
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html

-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-03-04 21:04:05
Subject: Re: A plan to improve error messages with context, hint and details.
Previous:From: tswanDate: 2004-03-04 20:06:43
Subject: Re: [HACKERS] Tablespaces

pgsql-advocacy by date

Next:From: David CostaDate: 2004-03-04 23:04:11
Subject: Re: RSS feed for PostgreSQL News ?
Previous:From: David CostaDate: 2004-03-04 19:45:30
Subject: Re: [pgsql-advocacy] RSS feed for PostgreSQL News ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group