Postgres Professional

What's New in PostgreSQL 18? | CommitFest 2024-07 Even though PostgreSQL 17 has just been released, the community is already hard at work on PostgreSQL 18! In our latest article, we dive into the first CommitFest for PostgreSQL 18 (July 2024) and explore some exciting new features. Here’s a quick preview of what’s been reviewed so far: 🔹Planner: Support for Hash Right Semi Join 🔹Planner: Materializing internal row sets for parallel nested loop joins 🔹Planner support for functions like generate_series 🔹EXPLAIN (ANALYZE): Statistics for Parallel Bitmap Heap Scan node workers 🔹Functions min and max for composite types 🔹Parameter names for regexp* functions 🔹Debug mode in pgbench 🔹pg_get_backend_memory_contexts: column path instead of parent, new column type 🔹Function pg_get_acl 🔹pg_upgrade: Optimization for pg_dump  🔹Predefined role pg_signal_autovacuum_worker Check out the full article for more details! 👇 https://lnkd.in/eZphUcWj

💡 New Weekly Series: Real Cases & Useful hashtag #PostgreSQL Features ➡️ Episode #4 Now that pgpro-otel-collector has had its public release, I’m excited to start sharing more about the tool — and to kick things off, I’m launching a blog series focused entirely on the Collector. The first post is an intro — a practical guide to installing, configuring, and launching the collector. We’ll also take our first look at what kind of data the collector exposes, starting with good old Postgres metrics. #postgres

✅ That’s a wrap on the BFSI Innovation & Technology Summit! Big thanks to everyone who stopped by the PostgresPro booth. It was great to connect, share ideas, and talk about how modern DBMS solutions like PostgresPro Enterprise can support data needs in banking, finance, and insurance. Shoutout to our team Andrey Fleyta, Mikhail Mironenko, Sheetal B. and Kedar Mantri for representing us so well! See you at future events! 🇮🇳 #BFSISummit #PostgresPro #DBMS #PostgreSQL #OpenSource #Fintech #Banking #Insurance #DigitalTransformation

Just 1 day to GO 🇮🇳 Postgres Pro team is excited to meet you tomorrow at the  BFSI Innovation & Technology Summit – Mumbai. 📅 7th August 2025 📍 JW Marriott, Juhu, Mumbai Explore how PostgresPro brings enterprise-grade PostgreSQL performance, data security, and flexibility to the heart of BFSI digital transformation. See you there! 👋

PostgresPro at BFSI Innovation & Technology Summit India 2025 Only 3 Days to Go! 🇮🇳 Just 3 days left until we head to Mumbai to connect with industry leaders and showcase how PostgresPro supports high-performance, secure, and scalable data solutions tailored for the financial sector. Visit our booth to discover: ▪️ Advanced PostgreSQL deployments for BFSI ▪️ Proven use cases from banking and fintech environments ▪️ Secure, compliant, and sovereign data infrastructure ▪️ Cost-effective migration strategies 📅 Date: 7th August 2025 📍 Venue: JW Marriott, Juhu, Mumbai Whether you’re a technology leader, architect, DBA, or digital strategist — don’t miss this opportunity to meet our team Andrey Fleyta Mikhail Mironenko Sheetal B. and Kedar Mantri and discuss how open-source database technologies are reshaping the BFSI landscape across India and beyond. Let’s talk PostgreSQL for financial innovation! #PostgresPro #PostgreSQL #BFSIIndia #OpenSource #Fintech #DatabaseSolutions #BankingTech #DigitalTransformation

Advanced Performance & Monitoring Tools 🎯 When running enterprise-scale databases, performance isn’t optional — it’s essential. Postgres Pro Enterprise includes a full suite of tools to ensure your system is always fast, stable, and predictable: ▪️ Diagnostic insights to detect bottlenecks early ▪️ Automatic parameter tuning to match your workload ▪️ Resource prioritization to ensure business-critical processes run first Whether you’re scaling up or optimizing usage — our advanced performance toolkit helps you stay efficient and responsive. Let your database work smarter, not harder. PS: Learn how Postgres Pro Enterprise can scale with your business: https://postgrespro.com/ Feel free to contact us for more details:  🌐 Worldwide: sales@postgrespro.com  🇮🇳 India: india@postgrespro.com #PostgresPro #CostEfficiency  #OpenSource #IndustrySolutions #PostgreSQL #DigitalTransformation  #HighAvailability #PostgreSQL #ScalableArchitecture #DBMS #EnterpriseDBMS

💡 New Weekly Series: Real Cases & Useful #PostgreSQL Features ➡️ Episode #3 Postgres Pro recently announced the release of Enterprise Manager 2, commonly known as PPEM. In short, PPEM is an administration tool designed for managing and monitoring Postgres databases. Its primary goal is to assist DBAs in their daily tasks and automate routine operations. In this article, I'll take a closer look at what PPEM has to offer. My name is Alexey, and I'm part of the PPEM development team.

Migrate From Legacy Systems Without the Headache💡 Migration can be intimidating — but it doesn’t have to be. With Postgres Pro Enterprise, enterprises confidently transition from Oracle and other legacy systems thanks to our wide set of powerful tools and hands-on expert support. Supported features include: ✔️ Oracle-style packages ✔️ System and application-level compatibility ✔️ The ora2pgpro utility for quick, reliable, and safe migrations ✔️ Handling of advanced data collections and packages Our migration experts ensure: ➡️ Zero data loss ➡️ Minimal downtime ➡️ Reduced total cost of ownership Whether you're looking to modernize, consolidate, or scale - we’re ready to make migration your smoothest step forward. PS: Talk to us today and discover what Postgres Pro Enterprise can do for your transformation journey. 🌐 Worldwide: sales@postgrespro.com  🇮🇳 India: india@postgrespro.com #DatabaseMigration #PostgresPro #PosgreSQL #LegacyModernization #DBTransition

🎯 Why Enterprises Choose Postgres Pro Enterprise Costly licenses, clunky migrations, security concerns, and performance bottlenecks — sound familiar? At Postgres Pro, we help you leave all that behind. Here’s what makes our solution an easy choice for modern enterprises: ✔️ Zero disruption with high fault tolerance and smooth migration tools ✔️ Enterprise-grade security for your most sensitive data ✔️ Adaptable to any industry and any workload ✔️ Reduces CAPEX and OPEX by 4–6x compared to legacy DBMS Maintains performance targets — even during live migrations. If your business depends on your data infrastructure — don’t settle for less than scalable, secure, and cost-efficient. It’s time to rethink your database strategy — with Postgres Pro Enterprise. Let’s upgrade your future. PS: Feel free to contact us for more details:  🌐 Worldwide: sales@postgrespro.com  🇮🇳 India: india@postgrespro.com #PostgresPro #CostEfficiency  #OpenSource #IndustrySolutions #PostgreSQL #DigitalTransformation  #HighAvailability #PostgreSQL #ScalableArchitecture #DBMS #EnterpriseDBMS

💡 New Weekly Series: Real Cases & Useful #PostgreSQL Features ➡️ Episode #2 In this article, we’ll explore what vector search is, what problems it solves, and how the pgpro_vector extension for Postgres Pro brings powerful vector capabilities directly into a relational database — no need for separate specialized systems. #Vector #PostgreSql #Vectorization #Databasedevelopment #Postgrespro #Vectordatabase #Vectorsearch #Databaseadministration