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
What is the difference between Oracle Client 19c and Oracle Client Home 19c?
When I tried to download and install Oracle client 19c, it was my surprise that there are two different versions. See the following information from…
View More What is the difference between Oracle Client 19c and Oracle Client Home 19c?
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
Enabling High Performance Data Streaming with the Memoptimized Rowstore
The Memoptimized Rowstore enables high performance data streaming for applications, such as Internet of Things (IoT). About the Memoptimized Rowstore The Memoptimized Rowstore enables high…
View More Enabling High Performance Data Streaming with the Memoptimized Rowstore
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