Re: [GENERAL] Re: Is PostgreSQL ready for mission critical applications?
At 11:48 AM 24-11-1999 -0500, Bruce Momjian wrote: >> > would you like it to work? What parts are too complicated? If they only >> > *appear* to be so, then this is a documentation deficiency, otherwise we'd >> > need to think about it. >> I think the concept of user friendly design is universal. There should be >> one button in the middle of the screen you push and everything is done for >> you :) (refer to technical support if you need to know more :) > >I refer to this as "helmet-ware". The software reads your mind, figures >out what you want it to do, and does it. And halfway you change your mind :). So it's still not fool proof. You need futureware. It'll predict what is really wanted and do that instead ;). In fact it doesn't need MVCC and stuff like that, since it knows what's going to happen. It'll have an Advanced Multi Universe Concurrency Control. Seriously tho. For things to be useful, there will always be a need for humans to make decisions. For databases and much software a single "Install Yes/No" is not satisfactory in sufficient cases to require additional decisions to be made during installation. The challenge is to organise the decisions/choices in as optimal a way as possible. For example: The useful and popular choices are more accessible/apparent, and the less popular ones don't clutter the others. At the same time, making them obvious and understandable. Not easy. Easy to go wrong. If you put only one button, sometimes the actual choice will be "Remove crappy software? (Yes/No)". Hey, how about putting this option: "Global Thermonuclear War? (Yes/No)". Of course that is only if Pg compiled with humour.h included. Cheerio, Link.
Re: [GENERAL] Re: Is PostgreSQL ready for mission critical applications?
> > would you like it to work? What parts are too complicated? If they only > > *appear* to be so, then this is a documentation deficiency, otherwise we'd > > need to think about it. > I think the concept of user friendly design is universal. There should be > one button in the middle of the screen you push and everything is done for > you :) (refer to technical support if you need to know more :) I refer to this as "helmet-ware". The software reads your mind, figures out what you want it to do, and does it. -- Bruce Momjian| http://www.op.net/~candle [EMAIL PROTECTED]| (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
[GENERAL] Re: Is PostgreSQL ready for mission critical applications?
The Hermit Hacker <[EMAIL PROTECTED]> wrote: : [...] : take a look at: : [list deleted] : Each one of those is mission critical to the person using it, and, in some : cases, I'd say to the ppl that they affect (Utility Billing and POS System : are the two that come to mind there)... : [...] Well, there are millions of people using Microsoft products for mission critical applications. I would never do that. :-) Maybe my standards are higher or my applications different. So this list really doesn't say much. The problem with databases in general is, that my standards for them are way higher then for most other pieces of software. If my web server failes, I restart it. If a mail server fails, I restart it, if syslog failes, I don't have a log file. But if a database failes, it is generally a lot more trouble. On the other hand a database is generally, apart from the kernel, the most complex thing running on your servers... : Quite frankly, I think the fact that Jochen is still around *even though* : he has problems says alot about the quality of both the software and the : development processes that we've developed over the past year, and also : gives a good indication of where we are going... This is true. Despite of the problems I had with PostgreSQL, the system I am using it for still runs PostgreSQL and it sort of works. We have to reload the database every once in a while, and some of the triggers, I would like to have, don't work. But basically it works. If you don't have the money to go for a commercial database, PostgreSQL is not a bad option. But don't think that everything with PostgreSQL is as bright, like some of the postings make you believe. Watch your database for performance and other problems, don't forget the backups and think about how to build your application that it failes gracefully if the database screws up. If you have an Oracle database you don't do that, you hire a DBA for it. There is no way you can do it yourself. :-) Jochen -- Jochen Topf - [EMAIL PROTECTED] - http://www.remote.org/jochen/
Re: [GENERAL] Re: Is PostgreSQL ready for mission critical applications?
On Mon, 22 Nov 1999, K.Tao wrote: > Well I do apologize as all my experiences are in the use of pre 6.5 > versions...I assume there have no longer been any reports of databases > having to be rebuilt or restored from tape from the way you are talking ;) > > Although I still feel that the level of expertise for an admin on a > Unix platform running PostgreSQL is much higher than lets say Oracle > on NT. One example is if you cancel out of a admin process like > vacuum while in pgsql. U have to have enough exp to know what files to > go and delete to be able to get pgsql back up and running. Actually, I believe the pg_vlock file is planned for removal in v7.0 ... just checked the current source tree, and this hasn't happened yet, but there was talk on -hackers about removing it since MVCC invalidates the requirement of locking all tables in a database while doing the vacuum... Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
Re: [GENERAL] Re: Is PostgreSQL ready for mission critical applications?
On Mon, 22 Nov 1999, Stephen Birch wrote: > I have been surprised by the response to this question. I was hoping that the > responses would be more consistent, after all when software is unreliable it > is generally known by all users. Steve - I tried to post an answer earlier (and it was verbose as is my tendency!) but apparently it bounced. I will cc the list, you and scrappy on this note. I converted my shop from FoxPro and PROGRESS (on UnixWare) to Postgres on Linux/BSD this past year. 12 years worth of data. My users are clinical staff *not* computer ppl (in fact they are computer-phobic) and have made myriad mistakes in entering and retrieving data via network and dialup connections. Our electricians have swapped feeder cables while my boxes were online - ouch. And I have made dubious errors in programming as I learned perl, CGI and DBI. But throughout it all, PG has suffered all of our blunders and our predilection for the text data type. Social Workers love to talk, even in their clinical progress notes. But PG rolls with the punches and everyday I find new reasons to love this database. Performance is good (better on UnixWare and BSD than Linux) and I am really happy that the Pg SQL is less idiosyncratic than Oracle. Perl has become a 4GL of sorts for me (replacing PROGRESS) and my > 140 character apps are now being ported to CGI for a netscape interface. They work well... I can't say enuf about how much I like postgres and - how much my users like it. They suffered with PROGRESS (slow) and FoxPro (corruption). I run Oracle on Linux and have tried Sybase and Informix too. I'll stick with Postgres. MySQL and mSQL are too much like flat file db's (concurrency control matters here) for me to even consider using them (I did try mSQL and didn't much care for it...) I use Pg ver 6.3.2 which is *rock* solid altho I'm told 6.5.x is faster. I may upgrade at some point but I feel very comfortable with 6.3.2 as I know it runs a wide array of mission critical apps with good speed and and good reliability. The tech support from the likes of Vadim and Bruce (and volunteers like Herouth M and Brett) is also something I've gotten used to...I often waffle between which unix I like best but I know which database I prefer. Cheers, Tom --- North Richmond Community Mental Health Center --- Thomas Good MIS Coordinator Vital Signs: tomg@ { admin | q8 } .nrnet.org Phone: 718-354-5528 Fax: 718-354-5056 /* Member: Computer Professionals For Social Responsibility */
Fw: [GENERAL] Re: Is PostgreSQL ready for mission critical applications?
From: K.Tao <[EMAIL PROTECTED]> To: The Hermit Hacker <[EMAIL PROTECTED]> Cc: Jochen Topf <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, November 22, 1999 12:38 PM Subject: Re: [GENERAL] Re: Is PostgreSQL ready for mission critical applications? > Well I do apologize as all my experiences are in the use of pre 6.5 > versions...I assume there have no longer been any reports of databases > having to be rebuilt or restored from tape from the way you are talking ;) > > Although I still feel that the level of expertise for an admin on a Unix > platform running PostgreSQL is much higher than lets say Oracle on NT. One > example is if you cancel out of a admin process like vacuum while in pgsql. > U have to have enough exp to know what files to go and delete to be able to > get pgsql back up and running. > > I do think that the commercial support program moves PostgreSQL much closer > to being a database I would choose. I havent had the requirement for that > support, but I am sure if I had a large system utilizing PostgreSQL I would > not hesitate to pay to make sure 24x7 I can get the database back up and > runniog within 15 mins of it going down :) > > I also do like the sound of getting rid of vacuum and its table locks. > Anythng to make the database more self administering and self recovering is > good ;) > > > > >