About
Denish Patel's background spans a wide depth and breadth of expertise and experience in SQL/NoSQL database technologies. Using this knowledge, he helped to architect and designed numerous successful database solutions addressing challenging business requirements. Denish is a Sr. Database Architect/Database engineer. He holds an MBA from the Johns Hopkins University and a BS in Computer Science, and has spoken at various conferences around the globe. He has experience working with various industries and companies - Medallia, WithMe, OmniTI.
"Why isn't my query using an index?" - Tips on SQL performance to keep on your finger tips!
presented by Denish Patel
If you are a Developer and/or a DBA, you must have come across this question: "why isn’t my query using an index?" This session explores the factors that influence the Postgres optimizer’s approach to this question. Learn about the concepts of cardinality and histograms and hear how these affect the optimizer's calculations. See a demonstration of how these concepts work in practice using real...
more Wed 20 2019 Development
Advanced Postgres Monitoring
presented by Denish Patel
video
Hands on session to setup Advanced Postgres monitoring using collectd and integrate with one of the SAAS based monitoring tool.
Fri 31 2017 Operations
Out of the Box Replication in PostgreSQL 9.4
presented by Denish Patel
Most people use at least one 3rd party script/tool to manage Postgres replication for building reliable solution for mission critical Postgres databases. Postgres 9.4's new features allow users to setup replication using built in features without compromising reliability and remove reliance on 3rd party tools. In this tutorial, I will walk you through replication options available in Postgres 9...
more Operations