Everyone knows the standard convention for plumbing fixtures: left is hot, right is cold. It’s a standard. This applies to two-handle faucets as well as single-handle faucets. But now we have this new crop of single-handle kitchen faucets without a right and left; you just have forward and backward. What’s the standard now? There’s no […]| Structure Tech Home Inspections
Earlier I had written a blog about partition-wise join in PostgreSQL. In that blog I had talked about an advanced partition matching technique which will allow partition-wise join to be used in more cases. In this blog we will discuss this technique in detail. I will suggest to read my blog on basic partition-wise join again to get familiar with the technique.| Walking with the Elephants
PGConf India 2018 attracted a large number of PostgreSQL users and developers. I talked about "Query optimization techniques for partitioned tables" (slides). Last year, I had held an introductory talk about PostgreSQL's declarative partitioning support (slides). Many conference participants shared their perspective on partitioning with me. One particular query got me experimenting a bit.| Walking with the Elephants