Lists: | pgsql-general |
---|
From: | Jan Pruner <pruner(at)cekia(dot)cz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Fwd: Re: Comparing PostgreSQL and Oracle stability |
Date: | 2002-07-04 10:47:56 |
Message-ID: | 200207041247.56906.pruner@cekia.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
-------------------------------------------------------
From: | Nils Höglund <nils(at)naqua(dot)se> |
---|---|
To: | Jan Pruner <pruner(at)cekia(dot)cz> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Fwd: Re: Comparing PostgreSQL and Oracle stability |
Date: | 2002-07-04 11:38:03 |
Message-ID: | 20020704133802.Y30034@Burk.hax.SE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
> 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