May 2023 – DBA Notes

SQL

Advanced SQL Techniques You Should Know

Bulent Soylu May 28, 2023 data analysis SQL

Window Functions Window functions allow you to perform calculations across a set of rows that are related to the current row. For example; we have…

Postgres

Understanding database Indexes in PostgreSQL

Bulent Soylu May 28, 2023 Indexes postgresql

There are three types of developers: those who know that indexes speed up database queries, those who know that indexes speed up database queries and…

Postgres

Understanding Postgres GIN Indexes: The Good and the Bad

Bulent Soylu May 23, 2023 gin performance postgresql

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…

performance Postgres

Performance Tuning Queries in PostgreSQL

Bulent Soylu May 23, 2023 performance postgresql tuning

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…

SQL

Correlated subquery

Bulent Soylu May 23, 2023 performance

In a SQL database query, a correlated subquery (also known as a synchronized subquery) is a subquery (a query nested inside another query) that uses values from the outer query. Because…

Postgres

Partitioning Large Tables

Bulent Soylu May 23, 2023 partitioning performance postgresql

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…