PostgreSQL: Cloning your instance can mess up replicationMany times we need to clone a production instance for some testing purpose. For example, validate a major version upgrade on a clone…Apr 11Apr 11
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 30Mar 30
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 30Mar 30
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
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