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@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@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


Thu, 04 Mar 2004 08:46:35 +0100
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <postgres@cybertec.at>
Regression tests on Nintendo Game Cube
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@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@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


04 Mar 2004 15:24:53 -0500
Robert Treat <xzilla@users.sourceforge.net>
Re: [HACKERS] Regression tests on Nintendo Game Cube
Robert,

> 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.

Can someone find me the original Hackers e-mail on Google groups, or 
something?   I'd like to report this to Slashdot, but I don't want to hammer 
our archives server.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


Fri, 5 Mar 2004 09:19:36 -0800
Josh Berkus <josh@agliodbs.com>
Re: [HACKERS] Regression tests on Nintendo Game Cube
Josh Berkus wrote:
> Robert,
> 
> > 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.
> 
> Can someone find me the original Hackers e-mail on Google groups, or 
> something?   I'd like to report this to Slashdot, but I don't want to hammer 
> our archives server.

Sure:

	http://groups.google.com/groups?q=game+cube+group:comp.databases.postgresql.*&hl=en&lr=&ie=UTF-8&group=comp.databases.postgresql.*&selm=4046DEDB.90506%40cybertec.at&rnum=1

You can link to the thread too if you prefer.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Fri, 5 Mar 2004 12:26:07 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] Regression tests on Nintendo Game Cube
People:

Submitted.   If don't get in, someone else try on Sunday, hey?

-- 
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology 	josh@agliodbs.com
    and data management solutions 	(415) 565-7293
   for law firms, small businesses 	 fax 651-9224
    and non-profit organizations. 	San Francisco


Fri, 5 Mar 2004 09:54:40 -0800
Josh Berkus <josh@agliodbs.com>
Re: [HACKERS] Regression tests on Nintendo Game Cube