Re: [HACKERS] Transaction system (proposal for 6.5)

Vadim Mikheev <vadim@krs.ru>

From: Vadim Mikheev <vadim@krs.ru>
To: Robson Miranda <rmiranda@rudah.com.br>
Cc: PostgreSQL hackers <pgsql-hackers@postgreSQL.org>
Date: 1998-09-25T02:43:28Z
Lists: pgsql-hackers
Robson Miranda wrote:
> 
>         I was thinking in a major rewrite of the PostrgreSQL transaction
> system, in order to provide less tuple overhead and recoverabilty.
> 
>         My first goal is to reduce tuple overhead, getting rid of xmin/xman and
> cmin/cmax. To provide this functionality, I'm planning to keep only a

I need in xmin & xmax for multi-version concurrency control...
Let's decide what should be implemented in 6.5...

>         To address the problem of non-functional update, I pretend to store a
> command identifier with the tuple, and, during update, see if the cid of
> a tuple is equal of the current cid of this transaction (like we do
> today).

cmin & cmax very simplifies implementation of data changes
visibility rules - I'm not sure is it ever possible to
do this having only one attribute for command id,
keeping in mind triggers, (PL/)SQL-funcs...

Vadim