Corruption (Was: Re: Why Not MySQL?)

As Don asks, what happened with the v7.0 trials you were doing? Corrupted
indices, I've seen occasionally in older versions, but I can't recall ever
seeing corrupt system tables ...

I don't have a GUI browser right, so searching the archives is kinda tough
for me :( Can you refresh my memory for me? There has to be something
logical to this, as to what the cause for the corruption is :(

From Don's comment, I take it you are using FreeBSD? Version? Stability
of the machine? Never crashes?

Version of PostgreSQL? Compile/configure options? Do you have any core
files in your data/base/* hierarchy that would be the result of a backend
crashing?

I know you are looking at alternatives, but I'm terrible at letting go of
problems :(

On Tue, 2 May 2000, Mitch Vincent wrote:

> A very, very good article. I love the comment about MySQL being a filesystem
> with an SQL interface :-)
>
> However.. I'm faced with a huge dilemma.
>
> We use PostgreSQL for a fairly large application I wrote, the database is
> still pretty small, it carries info on about 25-30,000 people and about
> 5,000 jobs. Recently we've had huge trouble with PostgreSQL -- it seems that
> every month I stump someone with the obscure things that happen to our data
> :-)
>
> >From corrupted indexes to corrupted system tables, it's almost always
> unrecoverable. Luckily I always have a backup to restore from and the world
> goes on... We've only recently started to notice that the backend is slowing
> down. It seems that with every additional applicant added it get
> exponentially slower... So, sadly I have to go find another backend for this
> application -- a commercial one too so we can get "commercial support"
> (yuck)..
>
> So, could you guys suggest some other backends I might look into? I know
> it's an odd place for me to ask but the flat truth is that I think *I* am to
> blame for my Postgres troubles and even taking all of the problems into
> account I think PG is the best damn free RDBMS out there. It's functionality
> is superior to everyone else's, it's developers are no less than amazing and
> well -- I trust you guys to give me some honest opinions.. The functionality
> I need is basically what PG has.. Transactions are a must as well as some
> sort of sequence -- stability over performance but performance is very
> important too. It also needs to run native on FreeBSD..
>
> Oracle is out as we use FreeBSD and someone out there decided that they
> wouldn't support FreeBSD (in the license as well as in the code!)..
>
> Thanks guys, especially to all who tried to help in private (Don, Tom --
> many others)..
>
> -Mitch
>
> ----- Original Message -----
> From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
> To: Don Baccus <dhogaza(at)pacifier(dot)com>
> Cc: <pgsql-hackers(at)postgresql(dot)org>
> Sent: Tuesday, May 02, 2000 5:55 PM
> Subject: Re: [HACKERS] Why Not MySQL?
>
>
> > >
> > > >Actually, I'm changing the link
> > > >
> > > >http://openacs.org/why-not-mysql.html
> > >
> > > Moments after forwarding the link to Ben's piece on why
> > > MySQL sucks to this list, he e-mailed me the above note.
> > >
> > > Sorry for any inconvenience...
> >
> > I am adding this to the FAQ.
> >
> > --
> > Bruce Momjian | http://www.op.net/~candle
> > pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> > + If your life is a hard drive, | 830 Blythe Avenue
> > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
> >
>

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org