#Postgres DBAs: cold page reads eating up query execution time on full table scans?

Some config params that help reduce I/O latency by 40%:

effective_io_concurrency = 200 (SSDs)
random_page_cost = 1.1
max_parallel_workers = 8

These changes (and others!) resulted in a 30% improvement in checksum time. Explore our latest blog for before/after EXPLAIN ANALYZE output + explanations behind each param at the DB and OS level.

https://www.pgedge.com/blog/optimising-cold-page-reads-in-postgresql

#tech #data #SQL #oracle #mysql #sqlserver #DBA

91% of enterprises require 99.99% uptime—yet 1 in 5 experienced a cloud region failure in the past year.

With 82% expressing concern, cloud resiliency is clearly top of mind.

Explore what IT leaders are doing to prepare in our PostgreSQL HA survey:
👉 https://www.pgedge.com/PostgresHAsurvey

#cloud #iot #education #finance #data #database #azure #aws #gcp

How do you solve AI latency across continents without breaking consistency? 💡

Enquire AI's case study shows the shift from traditional primary-replica to multi-master PostgreSQL architecture. The twist: pgvector + distributed nodes = local inference instead of cross-continent data shuttling. 🐘 🌐

Check out the full report on the AI Journal for the implementation details:

📖 https://aijourn.com/delivering-on-low-latency-edge-ai-with-distributed-postgresql/

#EdgeAI #PostgreSQL #IoT #tech #vector #ai #ml #saas #developer #data #aijournal

What are you using to manage failover within your #PostgreSQL deployments? According to the latest survey conducted by Foundry, built-in cloud provider solutions are top of the list - even though 21% of the respondents also directly experienced cloud region failure in the last year. 🤔

See what else enterprises are doing to address failover in the published survey results:
👉 https://www.pgedge.com/PostgresHAsurvey

#Postgres #SQL #data #datascience #edgeai #cloud #dataanalytics #iot #saas

#PostgreSQL is no longer just emerging—it’s embedded. 🐘

✅ 37% of enterprises run mission-critical apps on #Postgres
✅ 30% are standardizing it across most workloads

Explore what’s driving widespread enterprise adoption in the full survey:
👉 https://www.pgedge.com/PostgresHAsurvey

#database #tech #dev #enterprise #developer #edgenetworks

🚀 The latest Foundry survey of 212 IT decision-makers across enterprises and SaaS businesses found that 91 percent of organizations currently using PostgreSQL demand no more than four minutes of downtime per month, or around 99.99 percent uptime, while 24 percent aim for less than 30 seconds.

Learn more from co-founder and CEO of pgEdge, Phillip Merrick, in this article from the Register:

https://www.theregister.com/2025/07/22/postgresql_hyperscalers_gartner/

#PostgreSQL #TheRegister #pgEdge #CloudComputing #OpenSource #Gartner

🚀 Automating your pgEdge Distributed PostgreSQL deployments just got easier.

Discover the power of using Ansible with pgEdge to simplify and streamline your distributed PostgreSQL setup. From reducing manual steps to enabling repeatable, scalable deployments—this guide shows how to bring automation joy to your database workflows.

🔧 Read the full blog:
👉 https://www.pgedge.com/blog/the-joy-of-deploying-pgedge-using-ansible

#PostgreSQL #pgEdge #Ansible #DevOps #DatabaseAutomation #DistributedPostgres #HighAvailability

212 IT professionals (#PostgreSQL users!) from enterprises with 500+ employees talked about high availability, cloud outages, and more in the latest survey from Foundry and pgEdge:

👉 https://www.pgedge.com/PostgresHAsurvey

For example: 91% of enterprises require 99.99% uptime—yet 1 in 5 experienced a cloud region failure in the past year. Not to mention... ☁️ Cloud resiliency is clearly top of mind with 82% of all survey respondents concerned about risk.

#cloud #postgres #database #data #tech #developer

📹 Join Shaun Thomas in the upcoming (free!) "Postgres Live: Monthly Series" session for his discussion on "What's our Vector, Vector?", where you'll learn about using pg_vectorize to build a rudimentary self-maintaining RAG application with just a few PostgreSQL queries (August 5th, 1 PM EST).

Or, catch the recording of the session afterwards. 🐘

https://us02web.zoom.us/webinar/register/WN_dxXV8SkhRB6Y6veVN9kV9A#/registration

#postgresql #postgres #ai #ml #techwebinar #tech

🚨 More than 1 in 3 enterprises rely on PostgreSQL for mission-critical applications. Are you one of them?

See what’s driving adoption of PostgreSQL—and what’s holding teams back—in the latest survey report from Foundry. 📊

Read it here: https://www.pgedge.com/PostgresHAsurvey

#highavailability #edge #edgeai #database #opensource #postgres #postgresql