Published inNerd For TechThe Cost of a Bad Plan: Optimizer Misfire in ProductionDo not trust query optimiser to always run your query in the best possible way. Always double check the query plan. Be miser in disk reads.May 1May 1
Published inTowards DevCross Account Open search Cluster accessA guide to allow access to an open search cluster from a different account, different VPC and same region. A recommended approach to…Dec 28, 2024Dec 28, 2024
Published inTowards DevKinesis consumer using KCL in PythonHow to write a record processor using Kinesis Consumer Library in Python? Gain an in-depth understanding of AWS Kinesis stream processing.Dec 16, 2024Dec 16, 2024
Published inTowards DevHow do you add a constraint to the huge table in Postgres?Adding a check constraint to a huge production table without blocking reads or writes.Nov 9, 2024A response icon2Nov 9, 2024A response icon2
Published inTowards DevPartitioning in PostgresGuide to partition a table in Postgres.Nov 6, 2024Nov 6, 2024