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
Category: performance
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
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
Multiple rows insert vs single row insert
The performance of ‘extract, transform, load’ (ETL) processes for large quantities of data can always be improved by objective testing and experiment with alternative techniques.…
View More Multiple rows insert vs single row insert
APPEND_VALUES Hint in Oracle Database 11g Release 2
We have been able to take advantage of the performance benefits of direct-path inserts in “INSERT … SELECT” operations for a long time using the APPEND…
View More APPEND_VALUES Hint in Oracle Database 11g Release 2
Conventional and Direct Path Loads
Data Loading Methods SQL*Loader provides two methods for loading data: A conventional path load executes SQL INSERT statements to populate tables in an Oracle database. A direct…
View More Conventional and Direct Path Loads
Flush Bad SQL Plan from Shared Pool
Sometimes it is required to flush the BAD SQL_PLAN from shared_pool so that new (or old) better execution plan can be picked by SQL_ID 1)…
View More Flush Bad SQL Plan from Shared Pool
Postgres — Live Table Partitioning
the partitioning of 1TB of data on a live system, with zero downtime Summary A few months ago we faced an engineering challenge of having…
View More Postgres — Live Table Partitioning