Thread: Oracle vs Postgresql

Hello,

I didn't find a clear answer skimming throught the archives so I'll ask.

I currently have a running copy of Oracle 8 on our network.  The
university has a site license for it, so I set one up for our department
approx. 6 months ago with the intention of migrating alot of our work onto
it.  It's been setting idle since I installed it.  It didn't cost us a
thing since the university picks up the bill.

I'm using postgresql for an after hours GPLd project I'm doing for a
client and it seems to have come quite a ways since the last time I played
with it.

Now I'm ramping up the departmental database apps and was wondering....

Postgresql seems to offer me everything I'd need for the departmental
work, and I find myself wondering if the only reason for my keeping Oracle
around is to make the old resume look better. So....

Why keep Oracle?  Why switch to postgresql?

I'd really appreciate peoples thoughts on this.

->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
James Thompson    138 Cardwell Hall  Manhattan, Ks   66506    785-532-0561
Kansas State University                          Department of Mathematics
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

> Postgresql seems to offer me everything I'd need for the departmental
> work, and I find myself wondering if the only reason for my keeping Oracle
> around is to make the old resume look better. So....
>
> Why keep Oracle?  Why switch to postgresql?
>
> I'd really appreciate peoples thoughts on this.

I can't address the specific issues with Oracle because I have never
used it.

But, if you take a look at the web site www.postgresql.org, 6.5, due in
a month or two, will have MVCC locking, which is just like Oracle
locking, but better, I am told.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Hmm.

Due to my experience (I have played with boths) - if you need stable
network with predicted behaviour in case of disc overflow, bad (crazy)
requests, and you lost a lot of money in case of any instability - use
Oracle. If you need to deploy wide informational system, it should be
easy to upgrade, and you'd like to store images, textes, ip addresses,
use PSQL.

Oracle have (no doubt) wider opprotunities in the programmin requests,
better debugged internal rules, and much more stable in case of different
overflows; but it's slower (usially), waist a lot of memory (disk and
RAM), and cost a lot of money.

Our choise was - Oracle for the billing system, PSQL for the routing data
base and another internal data bases.


On Wed, 20 Jan 1999, James Thompson wrote:

> Date: Wed, 20 Jan 1999 16:13:50 -0600 (CST)
> From: James Thompson <jamest@math.ksu.edu>
> To: pgsql-general@postgreSQL.org
> Subject: [GENERAL] Oracle vs Postgresql
>
>
> Hello,
>
> I didn't find a clear answer skimming throught the archives so I'll ask.
>
> I currently have a running copy of Oracle 8 on our network.  The
> university has a site license for it, so I set one up for our department
> approx. 6 months ago with the intention of migrating alot of our work onto
> it.  It's been setting idle since I installed it.  It didn't cost us a
> thing since the university picks up the bill.
>
> I'm using postgresql for an after hours GPLd project I'm doing for a
> client and it seems to have come quite a ways since the last time I played
> with it.
>
> Now I'm ramping up the departmental database apps and was wondering....
>
> Postgresql seems to offer me everything I'd need for the departmental
> work, and I find myself wondering if the only reason for my keeping Oracle
> around is to make the old resume look better. So....
>
> Why keep Oracle?  Why switch to postgresql?
>
> I'd really appreciate peoples thoughts on this.
>
> ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
> James Thompson    138 Cardwell Hall  Manhattan, Ks   66506    785-532-0561
> Kansas State University                          Department of Mathematics
> ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
>
>
>
>
>

Aleksei Roudnev, Network Operations Center, Relcom, Moscow
(+7 095) 194-19-95 (Network Operations Center Hot Line),(+7 095) 230-41-41, N 13729 (pager)
(+7 095) 196-72-12 (Support), (+7 095) 194-33-28 (Fax)