Fwd: 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

-------------------------------------------------------

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

Haven't found any support of that in postgresql.

This is really a functionallity I miss (or have missed ;).

I solve the problem by sorting posts in my application (JSP). Works pretty
well, however - I would like the db to do the work.

> > 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.

I agree with your colleague. Writing you're queries "right" is
really important in Oracle. :)

--
/Nils Höglund, Naqua KB

E-mail: nils(at)naqua(dot)se
Web: http://www.naqua.se/
Home Phone: +46 (0)18 30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address: Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden