agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedproblem with postgres v4r2
2+ messages / 2 participants
[nested] [flat]
* problem with postgres v4r2
@ 1970-01-01 00:00 Sunay Tripathi <sunay@henna.iitd.ernet.in>
0 siblings, 1 reply; 2+ messages in thread
From: Sunay Tripathi @ 1970-01-01 00:00 UTC (permalink / raw)
To: ucb-postgres
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/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: problem with postgres v4r2
@ 1995-02-13 18:10 Paul M. Aoki <aoki@cs.berkeley.edu>
parent: Sunay Tripathi <sunay@henna.iitd.ernet.in>
0 siblings, 0 replies; 2+ messages in thread
From: Paul M. Aoki @ 1995-02-13 18:10 UTC (permalink / raw)
To: Sunay Tripathi <sunay@iitd.ernet.in>; +Cc: ucb-postgres; rekha@iitd.ernet.in
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/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1995-02-13 18:10 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1970-01-01 00:00 problem with postgres v4r2 Sunay Tripathi <sunay@henna.iitd.ernet.in>
1995-02-13 18:10 ` Paul M. Aoki <aoki@cs.berkeley.edu>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox