Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA06636; Wed, 24 Jul 91 02:18:57 -0700
Message-Id: <9107240918.AA06636@postgres.Berkeley.EDU>
From: boehlen@mint.inf.ethz.ch (Michael Boehlen)
Subject: SunOS Release 4.1.1
To: postgres@postgres.berkeley.edu
Date: Wed, 24 Jul 91 11:18:39 N

Shortly we moved from release 4.0.3 to release 4.1.1 on a sun 3/80.
Postgres doesn't seem to work properly with this SunOS release. First
of all the system
is very slow. But then it also fails to answer a lot of queries that
worked fine before.

Someone else who has similar problems?
Has someone a solution for these problems?

Thanks for answering   Mike Boehlen

Some results with SunOS release 4.1.1:
--------------------------------------
* retrieve (pg_class.relname)\g
  => answer time: 1 min 51

* create person (name = char16, age = int4, location = point)\g
  => answer time: 2 min 18

* create emp (salary = int4, manager = char16) inherits (person)\g
  => answer time: 3 min 58

* create p(c0=int4,c1=char16,c2=int4)
* retrieve (r0.all)
  from r0 in p, r1 in p
  where r0.c1=r1.c1
  and r0.c2=r1.c2
  => Error: No response from the backend, exiting...
     (The backend core dumps)

* retrieve (c0=r0.c0+r1.c0, c1=r0.c1, c2=r0.c2)
  from r0 in p, r1 in p
  where r0.c1=r1.c1
  and r0.c2=r1.c2
  and r0.c0=r1.c0
  => Error: No response from the backend, exiting...
     (The backend core dumps)

