agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Sunay Tripathi <sunay@kriti.iitd.ernet.in>
To: post-questions@postgres.Berkeley.EDU
Cc: postgres@postgres.Berkeley.EDU
Cc: ashutosh@yamuna
Subject: BUG in v4r2 or . ..
Date: Tue, 24 Jan 95 20:58:05 IST
Message-ID: <199501241528.UAA11043@kriti.iitd.ernet.in> (raw)

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/

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: sunay@kriti.iitd.ernet.in, post-questions@postgres.Berkeley.EDU, ashutosh@yamuna
  Subject: Re: BUG in v4r2 or . ..
  In-Reply-To: <199501241528.UAA11043@kriti.iitd.ernet.in>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox