dataiotech Labs
dbaguidedbaguideDBAdataxtoolsdataopsphere
Ana Sayfa/Veritabanları/sql-server/Derin Mimari/SQL Server Always On Read-Only Routing & Secondary Replica Latency
PostgreSQL → Performance Tuning → Memory Management
Derin Mimari & I/O Mimarisiadvanced12 mins read
PostgreSQL (14–18)

SQL Server Always On Read-Only Routing & Secondary Replica Latency

Load balancing read queries across secondary replicas using ApplicationIntent=ReadOnly and diagnosing redo queue lag.

PG
Senior SQL Server DBA
dbaguide.com PostgreSQL Derin Mimari Serisi
Standart: Buffered I/O•Kernel: Linux Page Cache•Blok: 8 KB Shared Buffers

▸Always On Read-Only Routing...

Community Discussion & Experience

Did increasing shared_buffers always improve performance in your PostgreSQL environment?

Share your observations regarding Linux Page Cache sizing, checkpoint spikes, and memory balancing across high-RAM PostgreSQL workloads.

Related PostgreSQL Architecture Guides
All Topics