Deepak Mahto @mahtodeepak05

Founder @ DataCloudGaze Consulting 🔀🚀☁️ | DatabaseGuy | Speed up by 3x your PostgreSQL migration? Let’s connect!

 Mumbai, India🇮🇳
linktr.ee/mahtodeepak
Joined March 2013
Introducing DCGMigrator ! DCGMigrator orchestrates the entire database migration journey, from assessment to validation, providing actionable insights at Day 1. datacloudgaze.com/post/intro…
2
1
5
Because of these i loved to Blog. It helped me learn new stuff from another experiences as well #PostgreSQL #Blogging
Planet PostgreSQL @planetpostgres
Nov 4
Deepak Mahto (@mahtodeepak05): PostgreSQL Partition Pruning: The Role of Function Volatility postgr.es/p/7kG
1
Deepak Mahto retweeted
Planet PostgreSQL @planetpostgres
Nov 5
Mayur B.: ALTER Egos: Me, Myself, and Cursor postgr.es/p/7kK
1
10
Ever wondered why your PostgreSQL queries skip partition pruning even when everything looks right? 🤔 In my latest blog, I’ve explained how function volatility affects pruning and performance with simple example from real migration projects. databaserookies.wordpress.co… #PostgreSQL
1
Deepak Mahto retweeted
Deepak Mahto @mahtodeepak05
Oct 6
Really happy that we helped an customer migrate away form @heroku to @googlecloud on Cloud SQL for PostgreSQL using Bucardo based trigger replication as minimal downtime based approach. #PostgreSQL #Heroku #CloudSQL #GCP #Bucardo
1
2
😎 Data like these pushes us @datacloudgaze to further improve migration and help a lot more customers migrate to Postgres #postgres
Grok
 @grok
Oct 31
Replying to @TweAllthaMatter @BdKozlovski
Based on 2025 data from DB-Engines, Statista, and Gartner reports: - Overall: Oracle leads (~30% share est.), MS SQL ~20%, Postgres ~15%, NoSQL (e.g., MongoDB) ~15-20%. - Enterprises: Oracle dominates (35-40%), MS SQL 25%, Postgres 15-20%, NoSQL 20%. - Small businesses: Postgres/MySQL ~30-35% each, MS SQL 10-15%, NoSQL 20%. - Public sector/Gov: Oracle/MS SQL 30-40% each, Postgres 10-15%, NoSQL limited (5-10%). Exact figures vary; sector data is sparse.
Deepak Mahto retweeted
Planet PostgreSQL @planetpostgres
Nov 4
Deepak Mahto (@mahtodeepak05): PostgreSQL Partition Pruning: The Role of Function Volatility postgr.es/p/7kG

PostgreSQL Partition Pruning: The Role of Function Volatility

Improper volatility settings in PostgreSQL functions can significantly impact query performance, especially with partitioned tables. Functions like now() and statement_timestamp() (STABLE) allow ef…

databaserookies.wordpress.com
4
1
27
Cutover Failed, Rollback!
Massimo
 @Rainmaker1973
Oct 19
Horror, and three words.
Deepak Mahto retweeted
Deepak Mahto @mahtodeepak05
Sep 14
DB migrations are personal to me—they connected me with the PostgreSQL community. At @datacloudgaze , empathy drives us. We’re the 1st engineers to walk every step of your migration, taking on the pain so your PostgreSQL journey begins with confidence from Day 1. #PostgreSQL
1
2
Deepak Mahto retweeted
Deepak Mahto @mahtodeepak05
May 10
Assuming i don't have to tell the PostgreSQL Version i am using, Explain Analyze will speak for itself! :) #PostgreSQL
1
Today is the special day. Moving away one of the customers from Oracle to PostgreSQL on GCP.
1
GIF
Deepak Mahto retweeted
PostgreSQL @PostgreSQL
Sep 25
News: PostgreSQL 18 Released! postgresql.org/about/news/po…

PostgreSQL 18 Released!

The [PostgreSQL Global Development Group](https://www.postgresql.org) today announced the release of [PostgreSQL 18](https://www.postgresql.org/docs/18/release-18.html), the latest version of the...

postgresql.org
33
414
53
2,264
PostgreSQL 18 is officially here! My Quick tips on checking top highlights from previous versions is using Feature Matrix postgresql.org/about/feature… Have fun with PostgreSQL 18! #PostgreSQL
1
Deepak Mahto retweeted
Deepak Mahto @mahtodeepak05
Sep 24
Replying to @masktejas
Yes I am at Dahisar metro station. Metro's from Dahisar to gundavli not operational only till Andheri West
1
1
Started with Oracle, now exploring PostgreSQL. Not here to say which is “better,” but to share learnings from Oracle to improve PostgreSQL practices. I focus on simplifying SQL performance monitoring—example: pg_sqltxplain github.com/dcgadmin/pg_sqltx… #PostgreSQL #Oracle #Comparision
1
2
2
Running PostgreSQL on Cloud SQL with high connections? 🚀 Check out Managed Connection Pooling 👉 cloud.google.com/sql/docs/po… Highly advise for cases where user connections requirement goes high in PostgreSQL on GCP.

Managed Connection Pooling overview  |  Cloud SQL for PostgreSQL  |  Google Cloud

cloud.google.com
2
The PostgreSQL extensions ecosystem never fails to amaze! Recently explored ddlx — an extension that generates DDL scripts using only SQL. Perfect for quick backup or analysis with pure SQL simplicity. Check it out:github.com/lacanoid/pgddl #PostgreSQL #Extensions

GitHub - lacanoid/pgddl: DDL eXtractor functions for PostgreSQL (ddlx)

DDL eXtractor functions for PostgreSQL (ddlx). Contribute to lacanoid/pgddl development by creating an account on GitHub.

github.com
1
Usage of pgextensions.org Source: i-programmer.info share.google/eQjWhUiS25ew4Rp…
1
Deepak Mahto retweeted
Deepak Mahto @mahtodeepak05
Sep 10
pgextensions.org/ We updated our curated extensions portal that bring all major cloud providers and its #PostgreSQL extensions supports. @neondatabase @aiven_io @awscloud @googlecloud @Azure @crunchydata @TigerDatabase Helps community to make wise decision with extensions.
1
1
Load more