Doug Fields wrote:
> At 08:11 AM 6/10/2002, Martijn van Oosterhout wrote:
> >there is no speed overhead. I'd be interested to know how MVCC would be
> >slowing anything down.
>
> I'd be interested in being able to turn it off and see if it speeds
> anything up. :)
>
> I didn't mean to imply that I _know_ that it slows things down. What I do
> know is that I a_ssume_ it does, and would like to be able to selectively
> disable it - in the hope of gaining speed at certain points. I figure the
> biggest speed gain will be because PostgreSQL can then skip writing
> anything to the transaction log. But then again, I also do not _know_ that.
MVCC is an integral part of how PostgreSQL's no-overwriting storage
manager works. It can't be turned of, and if it could, it wouldn't
provide _any_ speed increase.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026