Hi Christian,
On Sat, 10 Mar 2001, Christian Marschalek wrote:
> Since Oracle's prices are somewhat huge, I'm forced to switch to PostgreSQL!
> I would have used it from the start, if I just knew of it's existance ;o)
Oracle's prices are through the roof. Its crazy =)
>
> Now, I wonder if PostgreSQL is used for some commercial projects?
I am currently admin over 20 deployments of postgresql. They are all
within a commercial context.
>
> After all I've read about PgSQL, I'm preaty amazed of what it does!
> I know it's faster than MySQL and 2 other commercial products (which names I
> do not know), but I wonder how big the differance between let's say PgSQL
> and Oracle is ;o)
Depends what you want to do. Oracle has some nice features, like
clusterserver. This allows you to cluster your data store across multiple
machines. I was thinking for a while that I would build this into
PostgreSQL, but there are much easier ways to speed up transactions on the
database.
On the other hand, I have deployed PostgreSQL in some situations are an
Oracle replacement. I have never gotten into Oracle, but I have been
involved with running it on an E450, full decked. It ran like a dog under
the load ($60K US) - which was only a web site. Postgres on a Linux box
beat it hands-down.
Again, it depends on the application, but unless you are plugging a
third-party application into it, you can usually make PostgreSQL work
harder than Oracle on the same hardware. (If you're a code-cutter, then
you can tweak the source to suit your application too -- woohoo!)
Thanks
Gavin Sherry
Alcove Systems Engineering.