agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFrom: Sunay Tripathi <sunay@henna.iitd.ernet.in>
To: postgres@postgres.Berkeley.EDU
Subject: problem with postgres v4r2
Date: Mon, 13 Feb 95 17:48:11 GMT+5:30
Message-ID: <9502131218.AA17712@henna.iitd.ernet.in> (raw)
Friends,
I am in really deep shit. I have developed a major application on postgres.
For testing, I was using about 1000 records and every thing was fine. Once
I loaded the database, weird things started happening. Let me give you a
background -
1) I have installed postgres v4r2 on a Sun Sparc 10 running Solaris 2.3.
It has 64MB RAM and 150Mb Swap space. THe database has about 5 tables
having 3 to 7 attributes. Each table has about 20,000 records.
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. Because with exactly the same database
structure and same records, all the queries work on Postgres v4r1 under
SunOS 4.1.1.
So, is there any way to turn off the query optimiser (either at compile time
or at run time)?
Is anyone else facing similar problem with postgres 4.2 under Solaris 2.3?
Also, is postgres v4r1 available for Solaris 2.3?
I am really desparate and will appreciate any help that I can get.
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@henna.iitd.ernet.in
Subject: Re: problem with postgres v4r2
In-Reply-To: <9502131218.AA17712@henna.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