Re: Alter/update large tables - VERRRY annoying behaviour!

From: Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)nl>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Alter/update large tables - VERRRY annoying behaviour!
Date: 2002-04-16 10:19:12
Message-ID: 3CBBFAA0.1040305@oli.tudelft.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs pgsql-general pgsql-patches

Nigel J. Andrews wrote:
> On Mon, 15 Apr 2002, Nigel J. Andrews wrote:
>>On Mon, 15 Apr 2002, Dmitry Tkach wrote:
>>
>>>What's MVCC?
>>
>>Funny, I was about to ask that question. Something about variable size of
>>fields in the physical storage?
>
> I've remembered, alsmot: Multi Version ConCurrency?

Almost: Multi-Version Concurrency Control
http://www.postgresql.org/idocs/index.php?mvcc.html
http://www.onlamp.com/pub/a/onlamp/2001/05/25/postgresql_mvcc.html

If you need more info, Google is your friend.

Jochem

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Lara 2002-04-16 10:54:05 Postgresql on win2000
Previous Message Gianmarco Piola 2002-04-16 09:32:39 new problems

Browse pgsql-bugs by date

  From Date Subject
Next Message Michal Schwarz 2002-04-16 15:18:47 replace_vars_with_subplan_refs
Previous Message Thomas Lockhart 2002-04-16 02:33:05 Re: Bug #633: CASE statement evaluation does not short-circut

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2002-04-16 12:41:19 Testers needed ...
Previous Message CoL 2002-04-16 09:50:11 Re: speeding up subqueries

Browse pgsql-patches by date

  From Date Subject
Next Message Rod Taylor 2002-04-16 11:32:12 Re: [HACKERS] YADP - Yet another Dependency Patch
Previous Message Hiroshi Inoue 2002-04-16 05:23:48 Re: ANSI Compliant Inserts