Hi Tony,
PostgreSQL is *very* stable. Individual backends can be killed off by
weird SQL queries that trigger a known bug (not very many, and always
being fixed), but that is very very rare, and nothing which 99.999% of
normal SQL queries will get even close to.
There are a few 3rd party replication products for Solaris. The most
developed one I'm aware of is PostgreSQL Replicator
(pgreplicator.sourceforge.net).
The speed issue is a matter of sizing the database & hardware correctly,
you'll probably want to speak to a Commercial Support company for this.
And for Solaris support, I'd also advise contacting one of the
Commercial Support companies :
PostgreSQL Inc.
www.pgsql.com
GreatBridge LLC
www.greatbridge.com
In Japan, then Software Research Associates :
osb.sra.co.jp
In Vienna, Cybertec Geschwinde &. Schvnig OEG
postgres.cybertec.at
Further details of commercial support can be found at the PostgreSQL
Commercial Support page :
http://www.ca.postgresql.org/users-lounge/commercial-support.html
Hope this is helpful.
Regards and best wishes,
Justin Clift
Tony Hoyt wrote:
>
> I'm curious how PostgreSQL compares to Oracle in terms
> of stability and speed. My company is looking into
> alternative database software for our product but we
> need to know if it's stable enough for our needs.
>
> Our current requirements list for a good Database
> software application are the following.
>
> 1. Stability - It can survive power outages.
> 2. Speed - We're only going to perform very basic
> read and write transactions. Some tables are rather
> large but over all, we need a at least 200 sql
> transactions per second.
> 3. Redudency - Can we have two physical systems with
> one database being updated by the master database
> automaticly in case of failure. This is above and
> beyond RAID.
> 4. Solaris Support - I'm already positive that
> PostgreSQL can run on Solaris, but how well is it
> supported?
>
> If someone can adaquitly answer those issues for me,
> I would be extreamly greatfull. Thank you.
>
> Tony
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi
