1-What is a postgresql database cluster and database? A database cluster is a collection of databases managed by a PostgreSQL server. โDatabase clusterโ in PostgreSQL does not mean โa group of…
View More PostgreSQL Questions
Month: October 2021
Indexes in PostgreSQL (Bloom)
Bloom General concept A classical Bloom filter is a data structure that enables us to quickly check membership of an element in a set. The…
View More Indexes in PostgreSQL (Bloom)
Indexes in PostgreSQL (BRIN)
BRIN General concept Unlike indexes with which we’ve already got acquainted, the idea of BRIN is to avoid looking through definitely unsuited rows rather than…
View More Indexes in PostgreSQL (BRIN)
Indexes in PostgreSQL (RUM)
RUM Although the authors claim that gin is a powerful genie, the theme of drinks has eventually won: next-generation GIN has been called RUM. This…
View More Indexes in PostgreSQL (RUM)
Indexes in PostgreSQL (GIN)
GIN General concept GIN is the abbreviated Generalized Inverted Index. This is a so-called inverted index. It manipulates data types whose values are not atomic, but…
View More Indexes in PostgreSQL (GIN)
Indexes in PostgreSQL (SP-GiST)
SP-GiST First, a few words about this name. The “GiST” part alludes to some similarity with the same-name access method. The similarity does exist: both…
View More Indexes in PostgreSQL (SP-GiST)
Indexes in PostgreSQL (GiST)
GiST GiST is an abbreviation of “generalized search tree”. This is a balanced search tree, just like “b-tree” discussed earlier. What is the difference? “btree”…
View More Indexes in PostgreSQL (GiST)
Indexes in PostgreSQL (Btree)
Structure B-tree index type, implemented as “btree” access method, is suitable for data that can be sorted. In other words, “greater”, “greater or equal”, “less”,…
View More Indexes in PostgreSQL (Btree)
Indexes in PostgreSQL (Hash)
Structure General theory Plenty of modern programming languages include hash tables as the base data type. On the outside, a hash table looks like a…
View More Indexes in PostgreSQL (Hash)
Postgres Structure of the Access Method Interface.
Properties All properties of access methods are stored in the “pg_am” table (“am” stands for access method). We can also get a list of available…
View More Postgres Structure of the Access Method Interface.