Search Postgresql Archives

cmin increments by 2 except in 7.4?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I've noticed that in PostgreSQL 7.4, successive commands in a
transaction get cmin values that increment by 1, but in other
versions cmin increments by 2.  Example:

CREATE TABLE foo (x integer);
BEGIN;
INSERT INTO foo VALUES (1);
INSERT INTO foo VALUES (2);
INSERT INTO foo VALUES (3);
COMMIT;

Results in 8.0.1 (same in 8.1devel, 7.3.9, 7.2.7):

SELECT xmin, cmin, x FROM foo;
 xmin | cmin | x 
------+------+---
 7112 |    1 | 1
 7112 |    3 | 2
 7112 |    5 | 3
(3 rows)

Results in 7.4.7:

SELECT xmin, cmin, x FROM foo;
 xmin | cmin | x 
------+------+---
  856 |    1 | 1
  856 |    2 | 2
  856 |    3 | 3
(3 rows)

What is 7.4 doing differently than the other versions?

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux