Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199501241537.HAA03681@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
From: sunay@kriti.iitd.ernet.in (Sunay Tripathi)
Message-Id: <199501241528.UAA11043@kriti.iitd.ernet.in>
Subject: BUG in v4r2 or . ..
To: post-questions@postgres.Berkeley.EDU
Date: Tue, 24 Jan 95 20:58:05 IST
Cc: postgres@postgres.Berkeley.EDU, ashutosh@yamuna
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Tue, 24 Jan 95 07:37:16 -0800
Resent-XMts: smtp

Dear Sir,

We at IITD are facing some problems with our postgres v4r2.
I have done a standard installation on a Sparc 10/30 running
standard Solaris 2.3 with patches.

I have 4-5 tables in which I am searching for some data. As
long as no of records are less than 3000 records (in each table) there
is no problem. But as soon as I add another 500 records, I get the
message

"FATAL: no response from backend: detected in dump_data"

I have not loaded any function in the backend. One of my sample query
was -

	"retrieve unique (Name.Name, Address.Street, Address.City, Address.Zip,
Address.State, Address.Country, Address.E_mail, Phone.Areacode, Phone.Phone)
where Name.Name="GOLDEN CACHE" and Address.State="CA" and Name.Idno=Address.Idno
 and Address.Idno=Phone.Idno"

NOW if I make exactly same structure and same records in a postgres v4r1
running on a Sparc 1+ with SUNOS 4.1.1, there is no problem with any
kind of queries at all.

Now my QUESTIONS ARE -

1) Is there any patch available for postgres that I need?
2) Do I have to make some kernel configurations (I have 64Mb RAM)
3) Where can I get some info on kind of queries to make (to improve
	efficiency).

I'll appreciate any help that I can get from anybody.

Thanks.

Sunay

-- 
-----------------------------------------------------------------------
Sunay Tripathi, Senior Scientific Officer| Tel: +(91) 11 686-7431     |
ERNET, Dept. of Computer Science & Engg. | Fax: +(91) 11 686-8765     |
Indian Institute of Technology, Delhi,   |                            | 
e-mail : sunay@iitd.ernet.in             | Tel: +(91) 11 301-7186(Res)|
-----------------------------------------------------------------------


==============================================================================
   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/