Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id EAA19037 for postgres-redist; Tue, 24 May 1994 04:07:25 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199405241107.EAA19037@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from joyx.joensuu.fi (joyx.joensuu.fi [128.214.14.2]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id EAA19027 for <postgres@postgres.berkeley.edu>; Tue, 24 May 1994 04:07:22 -0700
Received: by joyx.joensuu.fi (5.57/Ultrix3.0-C)
	id AA18520; Tue, 24 May 94 14:03:54 +0300
Received: by gis.joensuu.fi.noname (4.1/SMI-4.1)
	id AA06161; Tue, 24 May 94 14:13:38 +0300
From: jsoi@gis.joensuu.fi (Janne Soimasuo)
Message-Id: <9405241113.AA06161@gis.joensuu.fi.noname>
Subject: Problems with indeces ???
To: postgres@postgres.Berkeley.EDU
Date: Tue, 24 May 94 14:13:38 EET DST
X-Mailer: ELM [version 2.3 PL11]
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Tue, 24 May 94 04:07:25 -0700
Resent-XMts: smtp

Hi netters !

I think I have some kind of problem with postgres indeces or am I doing 
something wrong ?

I have a forest inventory database, which have among others following 
tables (classes): 
ObsUni(ID=int4, Name=char16, SDate=abstime,
                EDate=abstime, CDate=abstime, LayerId=char16, ObjectId=int4, 
                Typ_OU=int2, ObsUni=int4, RefPoi=int4 )
and
ObsVal(ObsUni=int4, Int_Val=int2,Value=float8)

ObsUni class have about 7000 tuples and ObsVal ~ 70 000.

ObsUni is joined with ObsVal, Typ_OU, ObsUni and RefPoi classes.

To make queries faster I made some indeces:
1st btree:
define index ObsUni_ind1b on ObsUni using btree (ID int4_ops)\g
define index ObsUni_ind5b on ObsUni using btree (Typ_OU int2_ops)\g
define index ObsUni_ind6b on ObsUni using btree (ObsUni int4_ops)\g

define index ObsVal_ind1b on ObsVal using btree (ObsUni int4_ops) \g
define index ObsVal_ind2b on ObsVal using btree (Int_Val int2_ops) \g

and then hash:
define index ObsUni_ind1h on ObsUni using hash (ID int4_ops)\g
define index ObsUni_ind5h on ObsUni using hash (Typ_OU int2_ops)\g
define index ObsUni_ind6h on ObsUni using hash (ObsUni int4_ops)\g

define index ObsVal_ind1h on ObsVal using hash (ObsUni int4_ops) \g
define index ObsVal_ind2h on ObsVal using hash (Int_Val int2_ops) \g

The system fails when I try to create hash indeces. Is there something wrong ?


Another problem is that when I make a query like:
retrieve (ObsUni.all) where ObsUni.ObsUni NOTNULL
I got answer:
FATAL: no response from backend: detected in PQexec

This query runs well if I don't have any indeces with class ObsUni but
after I've made those I got an error.

I've tried this with Linux and with SunOS, but no solution !
Postgres version is 4.2.beta

Thanks in advance !

Janne Soimasuo
Faculty of Forestry
University of Joensuu, Finland
jsoi@gis.joensuu.fi

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================