Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199502131810.KAA29944@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Message-Id: <199502131810.KAA02350@faerie.CS.Berkeley.EDU>
From: aoki@cs.berkeley.edu (Paul M. Aoki)
To: sunay@iitd.ernet.in (Sunay Tripathi)
Cc: postgres@postgres.Berkeley.EDU, rekha@iitd.ernet.in
Subject: Re: problem with postgres v4r2 
Reply-To: aoki@cs.berkeley.edu (Paul M. Aoki)
In-reply-to: Your message of Mon, 13 Feb 95 17:48:11 GMT+5:30 
	     <9502131218.AA17712@henna.iitd.ernet.in> 
Date: Mon, 13 Feb 95 10:10:47 -0800
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Mon, 13 Feb 95 10:10:56 -0800
Resent-XMts: smtp

i don't know what's up with your mailers, but i've answered this at
least twice now (though the address before was Rekha Goel
<rekha@cse.iitd.ernet.in>)..

sunay@henna.iitd.ernet.in (Sunay Tripathi) writes:
> 2) The backend sometime crashes and sometimes gives wierd responses
> to my queries (specially if they have a join). I suspect that the
> query optimiser of postgresv4r2 is the real culprit.

can you elaborate on why you think the optimizer is the problem?
the optimizer runs to completion before any tuples are returned, so if
you get weird responses, it cannot be crashing in the optimizer.

> So, is there any way to turn off the query optimiser (either at
> compile time or at run time)?

no.  you can turn off `expensive function optimization' using 
	postmaster -o '-x off'

> Because with exactly the same database structure and same records,
> all the queries work on Postgres v4r1 under SunOS 4.1.1.

seems more likely that it's just instability on solaris.  there are
all sorts of differences between sunos 4 and sunos 5 that cause
different bugs to arise.  (changes to the way `malloc' works come to
mind.)

> Also, is postgres v4r1 available for Solaris 2.3?

not officially but there is some stuff under
  ftp://s2k-ftp.cs.berkeley.edu/pub/postgres/oldpost/postgres-v4r1/solaris2
that might or might not work.  you will need the modified gcc 2.5.8
that comes with the 4.2/solaris distribution or gcc 2.6.1 or later.
--
  Paul M. Aoki          |  University of California at Berkeley
  aoki@CS.Berkeley.EDU  |  Dept. of EECS, Computer Science Division (#1776) 
                        |  Berkeley, CA 94720-1776

==============================================================================
   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.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/