PinnedHüseyin DemirHow We Upgraded PostgreSQL Database Version with Near Zero DowntimeHi all, together with my colleague Ezgi, we completed the PostgreSQL database upgrade almost no downtime. That’s why we wanted to explain…5 min read·Jan 6, 2022--1--1
PinnedHüseyin DemirPostgreSQL’de SELECT Performansını Etkileyen FaktörlerMerhabalar, daha önceki bir çalışmamda PostgreSQL’de yazma hızına etki eden faktörleri aktarmaya çalışmıştım. Bu yazımda da okuma hızına…8 min read·Nov 17, 2021----
PinnedHüseyin DemirA New Approach to Scale RDBMS Platforms — YugabyteIn some areas of database engineering, we need to extend and improve our current architecture and technological infrastructure because of…7 min read·Aug 7, 2021----
PinnedHüseyin DemirPostgreSQL Veritabanında Yazma İşlemlerini Etkileyen Faktörler ve HızlandırmakMerhabalar, bu yazımda PostgreSQL veritabanındaki yazma işlemlerini ele almaya çalışacağım. Bu çalışma kapsamında da, PostgreSQL üzerinde…7 min read·Mar 28, 2021----
PinnedHüseyin DemirinSQL TürkiyePostgreSQL Logical Replication ile Online Database Upgrade YaklaşımıPostgreSQL üzerinde logical replication kullanarak kesintisiz veritabanı upgrade5 min read·Nov 14, 2020----
Hüseyin DemirPostgreSQL Configuration Chronicles: Memory Related ConfigurationsWe explore the fundamental role memory plays within the architecture of PostgreSQL databases, shedding light on the intricacies of…5 min read·Apr 24, 2024----
Hüseyin DemirPostgreSQL Configuration Chronicles: Updates and Fillfactor for Optimal Database PerformanceThe optimization of table configurations plays a pivotal role in achieving efficient data operations. PostgreSQL, renowned for its…7 min read·Apr 22, 2024----
Hüseyin DemirScaling Horizontally on PostgreSQL: Citus’s Impact on Database ArchitectureWhat exactly is Citus? Put simply, Citus is an extension for PostgreSQL that allows you to distribute your data and queries across multiple…9 min read·Apr 16, 2024----
Hüseyin DemirPostgreSQL Configuration Chronicles: Optimizing Timeout Settings for Performance ExcellenceEven the most powerful databases require fine-tuning to meet specific performance needs. One critical aspect of PostgreSQL optimization is…5 min read·Apr 9, 2024----
Hüseyin DemirOptimizing PostgreSQL Tables: Exploring Vacuuming Strategies to Combat BloatWhen it comes to managing a PostgreSQL database, one of the key concerns that database administrators face is bloat. Bloat refers to the…9 min read·Apr 8, 2024--1--1