At Stormatics, we believe PostgreSQL should be the most reliable part of your stack. We believe in empowering orgs to unlock PostgreSQL’s full potential.
Singapore
Joined March 2023
- Tweets448
- Following585
- Followers153
- Likes80
Stormatics retweeted
Umair Shahid (@pg_umair): PostgreSQL, MongoDB, and what “cannot scale” really means postgr.es/p/7nh
Stormatics retweeted
If Goldilocks were a DBA, she would put in the effort to try out instances till she got it 'just right'.
I will be conducting a webinar tomorrow to talk about optimizing your cloud strategy with PostgreSQL databases.
You can register here: resources.stormatics.tech/po…
Stormatics retweeted
Why is JSON so popular?
It's simple, flexible, and human-readable. Perfect for modern web dev, APIs, and data storage, it streamlines data exchange worldwide 🌐
🔗 documentdatabase.org/blog/js…
👏 for @pg_umair, @StormaticsTech
Stormatics retweeted
Master Explain Plans & Query Optimization in #Postgres!
⭐Join us in Islamabad on July 10 to learn from PostgreSQL Consultant Semab Tariq.
Networking, food & drinks included!
Register now: hubs.ly/Q02CYCVl0
Stormatics retweeted
#Database high availability is measured in 'nines'.
1 nine of availability is 90%
2 nines of availability is 99%
3 nines of availability is 99.9%
... and so on.
We can achieve up to 4 nines of #availability with #PostgreSQL by setting up a 3-node cluster with autofailover.
Stormatics retweeted
Periodic backups of PostgreSQL are crucial. The importance of verifying those backups is sometimes overlooked. Imagine a disaster strikes, and you discover your backup is faulty. Regularly verifying your backups ensures you won't face this.
More here: stormatics.tech/blogs/reliab…
Stormatics retweeted
Such an energized audience at the PostgreSQL User Group Meetup in Dubai last night - I loved it!
We talked about performance, scaling, and tips & tricks to make PostgreSQL do more with less.
In Dubai and are interested in participating? Register here: meetup.com/Dubai-PostgreSQL-…
Stormatics retweeted
muhammad ali: Logging Basics for PostgreSQL postgr.es/p/6tW
Stormatics retweeted
➡ Downtime can cost up to $85,000 per minute
➡ A single event's downtime cost can exceed $1 million
➡ Downtime causes costs like damage to reputation, loss of business, opportunity cost, poor user experience
Attendance is free - I'd love to meet and discuss!
Stormatics Founder, @pg_umair will be conducting the #Chicago #PostgreSQL Meetup on May 15!
Umair will be be presenting his talk on "Clustering in PostgreSQL: Because one #database server is never enough (and neither is two)"
👉 Register here: hubs.ly/Q02w3l5x0
Stormatics retweeted
7 key considerations FinTechs should be mindful of for PCI DSS compliance with PostgreSQL:
1️⃣ Data encryption
2️⃣ Access controls
3️⃣ Authentication
4️⃣ Masking of PAN
5️⃣ Audit trails
6️⃣ Regular testing
7️⃣ Data retention and disposal
Read more: stormatics.tech/blogs/pci-ds….
If you're in the FinTech and financial industries, don't miss out on @pg_umair's blog for tips on protecting payment data and meeting regulatory standards.
👉 hubs.ly/Q02v0rvl0
...
#PCIDSS #PostgreSQL #Compliance #Security #FinTech #PaymentCardIndustry
Stormatics retweeted
Struggling with #PostgreSQL bottlenecks? Umair Shahid @StormaticsTech shares tips for unlocking peak performance at #PGDay24 Ankara! Learn query tuning, indexing and why the future of tuning is AI. youtube.com/watch?v=YM7YnVv3… #database #AI #optimization
Stormatics retweeted
muhammad ali: PostgreSQL Roles and Privileges Simplified postgr.es/p/6sG
Stormatics retweeted
muhammad ali: Pitfalls of using SELECT * postgr.es/p/6sz
Stormatics retweeted
semab tariq: Build HNSW 80% Faster with Parallel Index Build in pgvector postgr.es/p/6sm
Stormatics retweeted
🐘🗣Next week, Umair Shahid and Jan Karremans will discuss why migrating from Oracle to PostgreSQL is ideal for mission-critical infrastructure.
Join them for a fireside chat on the 3rd April 2024, 3pm GMT.
➡ resources.stormatics.tech/fi…
#postgres #postgreSQL #migration #webinar
Stormatics retweeted
Simon, you left us too soon.
I am privileged and honored to have worked so closely with you. For your unwavering belief in me, for your guidance, for your friendship - THANK YOU
Life is so fragile. You will be sorely missed.
Stormatics retweeted
semab tariq: PostgreSQL Internals Part 2: Understanding Page Structure postgr.es/p/6s5
Stormatics retweeted
muhammad ali: Transitioning from Heroku PostgreSQL to AWS EC2: Step-by-Step Guide postgr.es/p/6s4
Stormatics retweeted
Explore key insights from a recent webinar by @pg_umair and Semab Tariq, comparing JSON performance in @PostgreSQL and @MongoDB
🔗Full article:
documentdatabase.org/blog/js…
Topics covered:
〽️Database Popularity Trends
🔄JSON Handling Evolution and JSON's Importance
⚙️Benchmarking Methodology
🔺 Performance Insights
🔎Select Query Performance Exploration
Stormatics retweeted
Looking forward to speaking about #PostgreSQL #performance in California!
Team Stormatics is headed to SCaLE next month! 🚀
Join us at one of the largest community-run #opensource & free software conferences in North America on March 14-17, 2024 at Pasadena Convention Center.
hubs.ly/Q02mF29s0
