Virender Singla·Mar 10The Part of PostgreSQL We Discuss the Most — 2PostgreSQL and Oracle Implementation
Virender Singla·Mar 10The Part of PostgreSQL We Discuss the Most — 1Early in my PostgreSQL journey, I often sensed that a conversation between two Postgres professionals inevitably revolves around vacuuming…
Virender Singla·Jan 10Idle Session Triggers a Transaction Wraparound?How an Unattended Session’s Temporary Table Bypasses Autovacuum and Triggers a Transaction Wraparound
Virender Singla·Dec 25, 2024When PostgreSQL Doesn’t Prioritize Consistency !How do concurrently running queries affect each other’s execution in databases? While MVCC (Multi-Version Concurrency Control) allows…
Virender Singla·Apr 11, 2024PostgreSQL: Logical Replication Cloning GotchaMany times we need to clone a production instance for some testing purpose. For example, validate a major version upgrade on a clone…
Virender Singla·Mar 30, 2024A Peek into Query Hash (query_id) in PostgreSQLPostgreSQL has an extension called pg_stat_statements to track top SQLs and it has queryid and query columns since ever (at least since I…
Virender Singla·Mar 30, 2024Understand SQL Query execution more closely: PostgreSQL Operator and CastIn RDBMS, a query execution goes through a number of steps like syntax and semantic checks, generate a parse tree with an optimized plan…
Virender Singla·Dec 16, 2021Postgres — Logical Replication and long running transactionsI was exploring logical replication in Postgres with respect to long running transactions and see how it replicates/behaves in different…
Virender Singla·Dec 8, 2021PostgreSQL Speed up VACUUM - Part 1In another article on VACUUM, We discussed the importance of VACUUM in PostgreSQL and provided a detailed questionnaire to help you…