Posted by WilliamC on Tue Nov 10 13:44:15 1998
In Reply to: Re: Re: new postgres posted by WilliamC pp TimJ on November 09, 1998 at 11:33:54:
| Distribution: | paneris@i-way.co.uk |
|---|
There are at least three stories in the PostgreSQL
mailing list archives of server crashes, including
one for the most recent version 6.4---achieved
using VIEWs, which seem to be acknowledged to be the
newest and least stable thing.(NB by server crash I mean you have to restart
postgres, not the whole machine---it's easy to
arrange for this to happen automatically on
Unix.)No reports of actual data loss though one person
did have to VACUUM (tidy) their database before
it would let them access it.There seem to be a surprising number of big university
sites using it. The complaint that appears on the
mailing list seems to be that it doesn't support
replication.They also list a fair number of commercial sites using
it.The bottom line is that it isn't perfect but that
with the exception of VIEWs, all its features have
been hammered pretty hard and haven't caused any
reported disasters.