RE: PostgreSQL 7.1 and ORACLE 8.x

You might add to that:

No limit on #transactions before dump/restore
Better language support (Java, Perl, etc)

Jon

johnnyb6(at)sdf(dot)lonestar(dot)org
SDF Public Access UNIX System - http://sdf.lonestar.org

On Fri, 8 Jun 2001, Willis, Ian (Ento, Canberra) wrote:

> Hi All
> Correct me if I'm wrong
> Oracle features not yet on postgresql
>
> Good Backup utilities, Backup backup API (compare the speed of a large dump
> on oracle to postgresql)
> Binary (fast) dump utility
> fine grained control of the filesystem layout from within the DB
> fine grained control of table spaces
> fine grained control of how the table_space grows ie no increase, increase
> by an decreasing/increasing amounts etc.
> Parrellel server (cluster storing a single DB) Allowing some queries to be
> sped up by throwing more machines at the problem.
> Threaded db backend allowing some queries to be speed up by throwing more
> processors at the problem.
>
> As far as I'm concerned thats about it. Currently the only ones that I would
> like to see fixed in the short term would be Online Backups followed by
> backups in general. The rest of the stuff on this list is not needed by 99%
> of people (but still nice to point to).
>
> What makes oracle the first choice is that by recommending it you use the
> "Nobody got fired for buying IBM" school, it is expensive, support is good
> and the CEO has heard of it.
> If you do use postgresql. Make sure that other people appreciate the
> alternatives and their cost beforehand, present it as a calculated risk, you
> are taking a risk on a technology that can give your company a competitive
> edge however as it is a new technology that may not have been tested in the
> role that you're anticipating. Be aggressive but don't be blinkered by your
> preference as well.
>
> Postgresql is a great product and very close to being a 24*7 product I don't
> think it quiet there yet.
>
> Postgresql is more advanced in a number of areas as well
>
>
>
>
>
> --
> Ian Willis
>
> -----Original Message-----
> From: Ptzke Axel (external)
> [mailto:Axel(dot)Paetzke(dot)external(at)kst(dot)siemens(dot)de]
> Sent: Thursday, 7 June 2001 5:11 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] PostgreSQL 7.1 and ORACLE 8.x
>
>
> Hello everybody out there,
>
> does anybody of you have experience with PostgreSQL 7.1 and
> ORACLE 8.x running simultaneously on the same server (Linux:
> Kernel 2.2.16), and could they be connected in any way to share
> some data ?
>
> As a beginner in client-server achitectured databases ( I only
> have a couple of years experience in programming PARADOX
> & ACCES databases), I also have the question, where are the
> main differences - except there is an open source software on
> the one hand and a commercial on the other - between these two
> databases?
>
> What does make ORACLE to be the first choice ?
> Under what kind of circumstances could be PostgreSQL the first
> choice ?
>
> After all: What are the main missing functions in PostgreSQL to
> put it to the same level as ORACLE - or does it still be ?
> If not: Will there be a chance in the near future, that I can
> supersede an ORACLE- database with a PostgreSQL one, under
> any circumstances ?
>
>
> I really don't want to start a database flame; all I want to get is a
> general overview based upon your experience - and yes, I have
> read the manuals allready, but maybe not everything in detail :-).
>
> Thanks for care and for helping me along
> Kind regards
> Axel
>
> "In a world without walls and fences,
> who needs windows and gates?"
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>