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)