Re: PgSQL MVCC vs MySQL InnoDB - Mailing list pgsql-general

From Jan Wieck
Subject Re: PgSQL MVCC vs MySQL InnoDB
Date
Msg-id 417D34B5.1050100@Yahoo.com
Whole thread Raw
In response to PgSQL MVCC vs MySQL InnoDB  (nd02tsk@student.hig.se)
Responses Re: PgSQL MVCC vs MySQL InnoDB  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-general
On 10/25/2004 11:53 AM, nd02tsk@student.hig.se wrote:

> Hello
>
> Harrison Fisk from MySQL claims in this thread:
>
> http://forums.mysql.com/read.php?35,3981,4245#msg-4245
>
> That there are no major differences between InnoDB and MVCC concurrency.
>
> Is this true?

 From a functional point of view, the two appear to do the same thing.
The implementation is certainly different and has pros and cons into
both directions. The statement is absolutely accurate and also explains
why Postgres never had any sort of file structure repair tools. I would
even go further in that you don't want to repair any corrupted files, as
those repair operations might introduce breakage of referential
integrity of your data.


Jan

>
> Thank you.
>
> Tim
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly


--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #

pgsql-general by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: Bug or stupidity
Next
From: Steven Klassen
Date:
Subject: Re: Bug or stupidity