-
Fixing Replication Lag with Parallel Logical Replication in Aurora PostgreSQL
Continue reading →: Fixing Replication Lag with Parallel Logical Replication in Aurora PostgreSQLOur nightly batch job kept freezing a downstream reporting dashboard for several minutes, and it turned out our Aurora PostgreSQL subscription was just waiting for one giant transaction to commit. Here’s how turning on parallel logical replication fixed it.
-
SQL Server 2025 Intelligent Query Processing: What Changed at Compatibility Level 170
Continue reading →: SQL Server 2025 Intelligent Query Processing: What Changed at Compatibility Level 170Bumping our database to SQL Server 2025’s compatibility level 170 quietly changed how two of our worst-behaved queries got their execution plans. Here is what Parameter Sensitive Plan optimization’s new DML support and Optional Parameter Plan Optimization actually did, and the monitoring query that broke along the way.
-
Priority Transactions: Letting the Database Roll Back Its Own Blockers in Oracle AI Database 26ai
Continue reading →: Priority Transactions: Letting the Database Roll Back Its Own Blockers in Oracle AI Database 26aiA hung transaction used to mean tracking down the blocker and killing the session by hand. In Oracle AI Database 26ai the database can roll back a lower-priority blocker automatically, and I walk through how to set it up and where it can bite you.
-
Automatic Transaction Quarantine in Oracle AI Database 26ai: When One Bad Transaction Won’t Take Down the Whole Database
Continue reading →: Automatic Transaction Quarantine in Oracle AI Database 26ai: When One Bad Transaction Won’t Take Down the Whole DatabaseOne transaction failing to recover used to mean the whole database could go down until Oracle Support helped you skip past it. In Oracle AI Database 26ai, SMON quarantines that one transaction instead, and I walk through monitoring and resolving it.
-
Oracle AI Database 26ai Is a Patch, Not an Upgrade: Reading the New Version Numbers
Continue reading →: Oracle AI Database 26ai Is a Patch, Not an Upgrade: Reading the New Version NumbersI was asked to scope a 26ai upgrade project the way we scoped our last major version move. Turns out if you are already on 23ai, it is just a quarterly patch, and I walk through the new version numbering that explains why.
-
WAIT and NOWAIT: Giving Every DML Statement a Lock Timeout
Continue reading →: WAIT and NOWAIT: Giving Every DML Statement a Lock TimeoutWho this is for: anyone who has run a one-off UPDATE, gotten pulled away before committing it, and come back to find three other sessions queued up behind a lock nobody could tell how long to wait for. A teammate was fixing a bad row in production last summer, a…
-
Small Oracle 23ai Syntax Wins That Saved Me Real Time
Continue reading →: Small Oracle 23ai Syntax Wins That Saved Me Real TimeA spreadsheet seed job and a rounding check on the same Friday showed me how much small Oracle 23ai syntax has quietly improved. Here is what multi-row inserts and select without from actually save, and where they still need care.
-
The Private AI Services Container: Vector Embeddings That Never Leave Your Network
Continue reading →: The Private AI Services Container: Vector Embeddings That Never Leave Your NetworkWho this is for: anyone whose security team has ever said “you can build semantic search, but nothing sensitive leaves this network to hit a third-party embeddings API,” and left you stuck doing keyword search instead. A healthcare client I worked with a while back wanted vector search over patient…
-
Aurora PostgreSQL 18 Upgrade Notes: B-Tree Skip Scans and What Actually Changed in Query Plans
Continue reading →: Aurora PostgreSQL 18 Upgrade Notes: B-Tree Skip Scans and What Actually Changed in Query PlansOur monthly reconciliation query was tripping a 300-second timeout because the planner couldn’t use a composite index without a tenant_id predicate. Aurora PostgreSQL 18’s B-tree skip scans fixed it without touching the query, and here are the actual before and after plans.
-
Select AI and Vector Search on a Legacy Oracle Schema: What It Actually Takes
Continue reading →: Select AI and Vector Search on a Legacy Oracle Schema: What It Actually TakesSelect AI and vector search work great on Oracle’s polished sample schemas. Production tables built over a decade tell a different story. Here’s what it actually took to get both working on ours, code included.
Database Administration & Architecture
Hi, I’m Arvind Toorpu.
I’m a Database Admin/Architect with 14+ years managing Oracle, SQL Server, and cloud (AWS/RDS) systems. This blog covers the cloning, tuning, security, and migration work that keeps databases running.
Hello,
Arvind Toorpu
I am a Database Admin/Architect with over 14+ years of experience managing multiple DBMS systems
Let’s connect
Join the fun!
Stay updated with our latest tutorials and ideas by joining our newsletter.
Recent posts
- August 2026
- July 2026
- August 2025
- July 2025
- June 2025
- May 2025
- April 2025
- March 2025
- February 2025
- January 2025
- December 2024
- November 2024
- September 2024
- August 2024
- July 2024
- June 2024
- May 2024
- April 2024
- March 2024
- February 2024
- January 2024
- August 2023
- June 2023
- May 2023
- May 2022
- November 2021
- August 2021
- April 2021
- January 2021
- March 2020
- November 2019
- February 2019
- December 2018
- June 2018
- June 2017
- April 2015
- March 2015
- February 2015
- January 2015
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- December 2013
- November 2013
- October 2013
- September 2013
- August 2013
- July 2013
- June 2013
- May 2013
Arvind Toorpu 