Re: Stability & Reliability

If you're just looking for experiences with PostgreSQL, here is a few
for you.

Our web server logging machine runs a development PostgreSQL snapshot
from a few weeks ago, does an average of 40,000 inserts a day plus the
selecting and processing all the statistic queries we run on it, it's been
running solid for a few weeks (and I don't see it failing anytime soon). We
have several million records, about 4 gigs of data and it's growing pretty
fast -- this is on a pretty puny box too, I think it's a older celeron with
about 128 megs of RAM and is running FreeBSD (of course!).

Another server running 7.0.3 that gets hit sort of hard everyday (about
300 agencies with an average of 10 people per agency smacking it around all
day) -- this one stores jobs and applcants (tens of thousands of them). The
box is up and running since I turned it on the first time, 243 days ago --
the database is pretty big too but I can't tell exactly as I don't have
access to that machine from here..

IMHO PostgreSQL is as stable and reliable as anyone could want it to
be..

-Mitch
Software development :
You can have it cheap, fast or working. Choose two.

----- Original Message -----
From: "Nadeem Akhtar" <nakhtar(at)mstic(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, March 29, 2001 1:18 PM
Subject: Stability & Reliability

> Hello,
>
> I'm in the process of performing analysis on Postgre SQL and other
> commercial DBMS including MySQL. Does anyone know where can I get
stability
> questions answered. I'm performing this analysis for a Dept of Defense
> contractor. The software will be used to conduct training exercises. The
> exercises will run for continously for 2 - 5 days. In this time frame the
> software also continously runs and collects and stores the data and
results.
> Therefore, stability is a must on the DBMS. I've discovered some negative
> remarks against MySQL stability but Oracle and other commercial ones have
> positive ones. But haven't been able to discover anything regarding
> Postgres ql.
>
> Thanks in advance.
>
>
>
> ---------------------------(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)
>