Write Concurrency in PostgreSQL is not consistent !How do concurrently running queries affect each other’s execution in databases? While MVCC (Multi-Version Concurrency Control) allows…Dec 25, 2024Dec 25, 2024
PostgreSQL: 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…Apr 11, 2024Apr 11, 2024
A 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…Mar 30, 2024Mar 30, 2024
Understand 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…Mar 30, 2024Mar 30, 2024
Postgres — 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…Dec 16, 2021Dec 16, 2021
PostgreSQL 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…Dec 8, 2021Dec 8, 2021
Published inNerd For TechPostgres — Parallel jobs with PythonRecently our team got multiple notifications from AWS for our Postgres Aurora clusters regarding deprecation of Postgres v9.6.x. We must…Apr 12, 2021Apr 12, 2021
Published inNerd For TechPostgres — Good for Queuing implementation?Few days back we got CloudWatch alarm alert for CPU Utilization for one of the Postgres database hosted on Amazon Aurora. Looking at…Apr 9, 20212Apr 9, 20212
Published inNerd For TechPostgres — Partial Index usage with Dynamic date filterRecently I was working on a slow running query. AS usual I checked different bind variables passed for that query and the count for those…Apr 2, 2021Apr 2, 2021
