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)?
Month: April 2023
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
Oracle SQL Profile swapping
SQL tuning is one of the main duty covered by Database Administrator. It is not easy and requires both technology knowledge and sql-development skills. It…
View More Oracle SQL Profile swapping
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
Oracle Automatic (Shared) Memory Management
Automatic Shared Memory Management Automatic Shared Memory Management: OverviewAutomatic Shared Memory Management (ASMM) simplifies the configuration of the System Global Area (SGA). ASMM uses memory…
View More Oracle Automatic (Shared) Memory Management
How do I display and read the execution plans for a SQL statement
This post covers how you can use the PL/SQL package DBMS_XPLAN to display execution plan information. If you want to learn more about DBMS_XPLAN options,…
View More How do I display and read the execution plans for a SQL statement
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