文稿中的数字和图片

取自 PostgreSQL Wiki
跳转到导航跳转到搜索

PGCon 2016 用户非正式会议中的一个行动项目是,我(Heikki)尝试使用 ASCII 艺术绘制 GIN 索引的插图,看看此类实践中 ASCII 艺术对图表的效果如何。这是我的成果

********************************************************************************************
*                                                                                          *
* +----------+                                            +-----------------+              *
* | Metapage |                                            |                 |              *
* +----+-----+   +---------------------------------+      |          +---+  |              *
*      |         |                                 |      |       -->|   |  |              *
*      |         |                         +---+   |      | +---+/   +---+  |              *
*      |         |                      -->|   +----------->|   +           |              *
*      |         |                +---+/   +---+   |      | +---+\   +---+  |              *
*      |         |             -->|   +            |      |       -->|   |  |              *
*      |         |            /   +---+\   +---+   |      |          +---+  |              *
*      |         |           /          -->|   |   |      |                 |              *
*      |         |          /              +---+   |      | Posting tree    |              *
*      |         |         /                       |      +-----------------+              *
*      |         |        /                +---+   |                                       *
*      |         |       /              -->|   |   |                                       *
*      |         | +---+/         +---+/   +---+   |                                       *
*      |         | |   +--------->|   +            |                                       *
*      |         | +---+\         +---+\   +---+   |                                       *
*      |         |       \              -->|   +------->                                   *
*      |         |        \                +---+   |                                       *
*      |         |         \                       |                                       *
*      |         |          \              +---+   |                                       *
*      |         |           \          -->|   |   |                                       *
*      |         |            \   +---+/   +---+   |                                       *
*      |         |             -->|   +            |                                       *
*      |         |                +---+\   +---+   |                                       *
*      |         |                      -->|   |   |                                       *
*      |         |                         +---+   |                                       *
*      |         |                                 |                                       *
*      |         | Entry tree                      |                                       *
*      |         +---------------------------------+                                       *
*      |                                                                                   *
*  +---|------------------+                                                                *
*  |   V                  |                                                                *
*  | +---+  +---+  +---+  |                                                                *
*  | |   |->|   |->|   |  |                                                                *
*  | +---+  +---+  +---+  |                                                                *
*  |                      |                                                                *
*  | Fast update list     |                                                                *
*  +----------------------+                                                                *
*                                                                                          *
********************************************************************************************