健哥的数据花园

摘要： 看了PostgreSQL的代码后，我觉得有不理解的地方，比如：例如这样的：/* Options that may appear after CATALOG (on the same line) */#define BKI_BOOTSTRAP#define BKI_SHARED_RELATION#define BKI_WITHOUT_OIDS#define BKI_ROWTYPE_OID(oid)#define BKI_SCHEMA_MACROCATALOG(pg_tablespace,1213) BKI_SHARED_RELATION{ NameData spcname; ... 阅读全文

摘要： 先说 heap_insert 函数：/* * heap_insert - insert tuple into a heap * * The new tuple is stamped with current transaction ID and the specified * command ID. * * If the HEAP_INSERT_SKIP_WAL option is specified, the new tuple is not * logged in WAL, even for a non-temp relation. Safe usage of thi... 阅读全文

摘要： 看例子：开两个终端来对比：在终端A:[pgsql@localhost bin]$ ./psqlpsql (9.1.2)Type "help" for help.pgsql=# begin;BEGINpgsql=# select xmin,xmax,cmin,cmax,* from tab01; xmin | xmax | cmin | cmax | id | cd ------+------+------+------+-----------+---- 1878 | 0 | 0 | 0 | 1 | 1 1884 | 0 | 0 | ... 阅读全文