Adding, tuning and removing indexes is an essential part of maintaining an application that uses a database. Oftentimes, our applications rely on sophisticated database features…
View More Understanding Postgres GIN Indexes: The Good and the Bad
Tag: postgresql
Performance Tuning Queries in PostgreSQL
Database performance tuning: developers usually either love it or loathe it. I happen to be one that enjoys it and want to share some of…
View More Performance Tuning Queries in PostgreSQL
Partitioning Large Tables
About Table Partitioning Partitioning does not change the physical distribution of table data across the segments. Table distribution is physical: Greenplum Database physically divides partitioned…
View More Partitioning Large Tables
PostgreSQL EXPLAIN Explained
When a SQL statement is sent to a PostgreSQL server for execution, Postgres will decipher various parts of the query and define an execution plan…
View More PostgreSQL EXPLAIN Explained
TOAST compression and toast_tuple_target
What is the TOAST ? Have you ever wondered how Postgres stores rows that exceed the size of a block? As a reminder, the default…
View More TOAST compression and toast_tuple_target
LZ4 TOAST compression in PostgreSQL 14
Background In PostgreSQL, a page is the basic unit to store data, and the size of each page is 8 kB by default. Basically, data in one…
View More LZ4 TOAST compression in PostgreSQL 14
Postgres Locks
Table Locks If you ask me what a table lock three years ago I would say its a lock you obtain on a table so…
View More Postgres Locks
How to measure performance of PostgreSQL Database Server(s)?
The benchmark test is designed to evaluate and compare the performance of different configurations, topologies, systems and components. For this purpose I will use the…
View More How to measure performance of PostgreSQL Database Server(s)?
Speeding Up “min” and “max” functions in postgresql
Indexes are a perfect tool to finding a certain value or some kind of range in a table. It is possible to speed up a…
View More Speeding Up “min” and “max” functions in postgresql
How to Use Materialized Views in PostgreSQL
Introduction: About Views and Materialized Views For a complex SQL query, it is impractical to rewrite the entire query every time its results are needed. Views solve…
View More How to Use Materialized Views in PostgreSQL