Index in PostgreSQL -- Btree
We have discussed the interface of index engine and access method of PostgreSQL, as well as hash index. Now we will consider the b-tree, the most traditional and widely used index. This article is very long, please wait patiently.
Btree structure
B-tree index type, implemented by « btree » access method, is suitable for sortable dat ...
Posted by acook on Sun, 22 May 2022 15:15:48 +0300
MVCC for PostgreSQL -- In-page vacuum and HOT updates
in-page vacuum and HOT update, both techniques can be called optimization. They are important but not actually included in the documentation.
Perform in-page vacuum during regular updates
When a page is accessed for a read or update, PostgreSQL can perform a quick in-page vacuum if it knows the page is out of space. Happens in the following two ...
Posted by halfman on Thu, 19 May 2022 14:41:11 +0300