Обсуждение: Unexpected crashes
Hi all, I've just subscribed to the list this morning, as we are considering installing Postgres for a particular project. I guess I'm a little apprehensive, as perhaps coincidentally, this is the second reference to unexpected crashes that I have heard in as many days . Does this occur often? Cheers Tony Bazeley >As my own side note, on Postgres 7.0.2, I at one point tried creating >a view which said >CREATE VIEW silver_view AS >SELECT * from jcombo_query WHERE metal_uid = 1 ; >and so on for elec, gold, plat. And then used these to simplify the >main query. This caused Postgres to go away permanently, and I had >to manually delete the database.
I've used PostgreSQL for pretty much any project I've required an RDBMS in for the past 4+ years now ... VIEWs haven't figured very prominently in that, but I can't really say that I've noticed any major problems with unexpected crashes in the past 2 years or so ... In the below, the user was doing a VIEW of a VIEW (jcombo_query is a VIEW) ... I tried what he was thinking of myself, on my machine, but withoutu the VIEW of a VIEW, and it didn't cause any lockups on my machine ... the problem with what is below is that he doesn't explain hat "go away permanently" means ... did the query just never end? did the postmaster crash and he couldn't restart it? etc, etc ... On Fri, 8 Sep 2000, Tony Bazeley wrote: > Hi all, > > I've just subscribed to the list this morning, as we are considering > installing Postgres for a particular project. > > I guess I'm a little apprehensive, as perhaps coincidentally, this is the > second reference to unexpected crashes that I have heard in as many days . > > Does this occur often? > > Cheers > Tony Bazeley > > >As my own side note, on Postgres 7.0.2, I at one point tried creating > >a view which said > >CREATE VIEW silver_view AS > >SELECT * from jcombo_query WHERE metal_uid = 1 ; > >and so on for elec, gold, plat. And then used these to simplify the > >main query. This caused Postgres to go away permanently, and I had > >to manually delete the database. > > > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
I've been running 6.5.3 since March and it has never failed. That's continuously since March too. Never more than 10 users at a time, and only about 2 Gig data, but there it is, rock solid. I would like to go to 7.something, but when you are having nothing but joy and happiness, why change? -----Original Message----- From: Tony Bazeley [mailto:tonyb@mrc.org.au] Sent: Friday, 8 September 2000 2:19 To: pgsql-general@postgresql.org Cc: jesse@va.com.au; lees@gardener.com Subject: [GENERAL] Unexpected crashes Hi all, I've just subscribed to the list this morning, as we are considering installing Postgres for a particular project. I guess I'm a little apprehensive, as perhaps coincidentally, this is the second reference to unexpected crashes that I have heard in as many days . Does this occur often? ********************************************************************** The information contained in this e-mail is confidential and is intended only for the use of the addressee(s). If you receive this e-mail in error, any use, distribution or copying of this e-mail is not permitted. You are requested to forward unwanted e-mail and address any problems to the MIM Holdings Limited Support Centre. e-mail: supportcentre@mim.com.au phone: Australia 1800500646 **********************************************************************