Stormatics
@StormaticsTech
Followers
153
Following
78
Media
214
Statuses
320
Stormatics provides PostgreSQL Professional Services for SMBs with a mission to help them scale Enterprise-grade PostgreSQL reliably for their critical data.
Singapore
Joined March 2023
Happening tomorrow. Last chance to register. Join Mughees Ahmed and Warda Bibi of Stormatics on 17 December 2025 at 3:00 PM GMT for a session on improving production PostgreSQL performance. Register now: https://t.co/0vg7VTPgGN
0
0
0
A claim that PostgreSQL could not scale misses the real cause, which is usually design or operational choices. Umair Shahid explains how tuned nodes, replication, partitioning, and distributed systems keep PostgreSQL scaling. Read the blog: https://t.co/NRpdsKQjDb
0
0
0
In a Patroni based PostgreSQL cluster, HAProxy keeps applications running during failover. When a new primary is promoted, HAProxy detects the change and reroutes traffic to the active node automatically, protecting uptime and SLAs. Learn more at https://t.co/QQvOfwEFY4
0
0
0
You don’t need to unlearn Oracle to move into PostgreSQL. This one-day intensive maps Oracle concepts to real PostgreSQL production operations. Registration closes at 11:59 PM GMT. Register here: https://t.co/ybSxNZKfHf
0
0
0
Knowing how PostgreSQL locks work helps you avoid deadlocks and slow queries. Locks protect data but can limit scale when poorly managed. Learn the basics, common pitfalls, and mitigation techniques in the blog : https://t.co/eXOxyFZ1bw
0
0
1
Experienced Oracle DBA moving to PostgreSQL? You don’t need to start over, just learn where the architectures align and differ. Stormatics is bringing back its One-Day Intensive PostgreSQL Training for Oracle DBAs at $150. Reserve your spot: https://t.co/eqTB190F1w
0
0
0
ORDER BY with LIMIT can be slow on large tables because PostgreSQL must sort before returning rows. Our test took 68 ms for only five rows. After adding an index, it dropped to 0.05 ms. Semab breaks down why indexing removes the sort. Details here: https://t.co/bnDNJJtv2Y
0
0
0
A client used manual pg_dump backups for an 800GB PostgreSQL database, risking failure and poor performance. We migrated them to pgBackRest with off site encrypted backups, automated retention, and PITR. Faster and safer. Blog: https://t.co/SNRu3pRGnM
0
0
0
Final call to register for tomorrow's webinar. Semab Tariq and Warda Bibi from Stormatics will show how to reach 99.99% PostgreSQL uptime using TPA, Patroni, pgbouncer, and Barman, with guidance for reliable deployments. Register now: https://t.co/iI6d0L8gsN
0
0
0
Generating complex Odoo reports slowed one customer’s system to a crawl. PostgreSQL looked fine, but monitoring showed the real issue: not enough memory. After increasing RAM and tuning shared_buffers, reports ran 93% faster. Full story here: https://t.co/vKMPofIMRh
0
0
0
Join our One-Day Intensive PostgreSQL Training for Oracle DBAs on Dec 11. Get hands-on instruction in architecture, setup, security, indexing, backups, and replication. Final chance for the $150 rate. Register now: https://t.co/89YieD7GVP
0
0
0
Patroni keeps HA simple with clean failover and leader control, while Pgpool II adds pooling, load balancing, and routing in one layer. If you’re sorting out which approach fits your PostgreSQL setup, this breakdown is a solid guide: https://t.co/oYiW5x9cPp
0
0
0
Achieve four nines of uptime for PostgreSQL using only open source tools. Join Semab Tariq and Warda Bibi from Stormatics to learn how TPA, Patroni, pgbouncer, and Barman deliver production-grade HA without added cost. Register: https://t.co/ziErTs3YTw
0
0
0
Split-brain in PostgreSQL HA clusters can cause conflicting writes & data loss when nodes lose communication. Learn what it is, how it happens, & how tools like Patroni + ETCD prevent it. Learn more: https://t.co/qodBw3ANoh
0
0
0
Many PostgreSQL setups start fine on defaults, patched with quick fixes. Then come slow queries, lockups, and outages. This checklist covers availability, performance, backups, security, monitoring, scaling, maintenance, and support. Read more: https://t.co/6torQSb07S
0
0
1
PostgreSQL delays writing changes to disk, updates first live in memory as “dirty pages.” It’s efficient, but when these pages pile up, performance can stall. Umair Shahid explains how Postgres manages dirty pages and how to tune for smoother performance: https://t.co/iKZH7ilxD9
0
0
0
Upgrading your PostgreSQL database doesn’t have to mean downtime. We’ve perfected zero-downtime upgrades, keeping your systems live while boosting performance, security, and scalability. See how we helped Whop migrate from Heroku to AWS without disruption: https://t.co/QLjKpBmoJT
0
0
0
Managing concurrent updates in PostgreSQL can be tricky. Umair Shahid explains how SELECT FOR UPDATE locks rows to prevent conflicts, keep data consistent, and improve performance. Read the blog: https://t.co/slxJmgyPuG
#PostgreSQL #SQL #Databases
0
0
0
PostgreSQL 18 is here with major performance upgrades. Join Bruce Momjian and Umair Shahid on Nov 12 at 3:00 PM GMT as they explore what’s new, how it impacts production workloads, and how to avoid costly downtime. Register: https://t.co/1qJBSJDw39
0
0
0
PostgreSQL on large multi-CPU systems brings new challenges. Memory access isn’t uniform, that’s where NUMA matters. Learn why NUMA exists, how it works, key Linux policies, and migration challenges: https://t.co/AUYqeQZm6t
0
1
1