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