Re: Comparing PostgreSQL and Oracle stability

Support PostgreSQL in some way hierarchical query like Oracle does?
Select ... start with ... connect by ... ???

JP

On Thursday 04 July 2002 11:18, you wrote:
> > I'm considering porting code from Oracle to PostgreSql. I'm looking
> > for opinions from people that are experienced with both PostgreSQL and
> > Oracle:
> >
> > 1) Is the stability better, equal or worse when comparing Oracle 9i?
> > 2) Are there any performance issues to be aware of when comparing
> > PostgreSql an d Oracle (on the same hardware configuration) - eg. size
> > of table colums, count of records in tables (and indexes).
> > 3) And how about the work for DB administrators - are things simpler
> > or more complicated?
>
> First off, I don't have much experience with Oracle, but I have done a
> couple things with it, and one of my colleagues has used it much more
> extensively.
>
> 1) stability - I have not had stability problems with a recent release of
> postgresql. The developers sometimes mention potential problems, but I
> haven't encountered one (at least after 7.1, before that I seem to remember
> a couple minor issues). I haven't heard of any problems with oracle.
>
> 2) I can't provide you with any meaningful info about performance. I didn't
> do any scientific performance comparison. One thing I can say, is that my
> colleague needed to spend a lot of time giving hints to oracle because
> (according to him) the planner was really bad and frequently made planning
> errors.
>
> 3) Much easier to administrate postgres. I gave up trying to get oracle
> working myself.
>
> Regards,
> Jeff
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Pruner Jan
jan(at)pruner(dot)cz
http://jan.pruner.cz/
-----------------------------
Only Robinson Crusoe had all his work done by Friday