Top all-time · #2983
pgEdge
Company blog · pgedge.com/blog · on HN as pgedge_postgresdataprogrammingbusiness
pgEdge is the company blog at pgedge.com, writing about data, programming and business. Since 2023, 26 different Hacker News readers have linked it 58 times, most often “Understanding conflict resolution and avoidance in PostgreSQL: a complete guide”. No feed was found, so read it on the site itself.
Too few sampled comments (7) to say how often HN recommends it.?
Why HN links it
HN readers link pgEdge's blog for Postgres operations: zero-downtime upgrades, logical replication with pgbouncer pause/swap, memory tuning, and multi-region, multi-writer high availability.
Summarised by Claude from a sample of 7 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Build agentic AI and enterprise applications on 100% standard Postgres - then deploy on our cloud, your cloud, or your on-premises infrastructure, without ever changing platforms.
Most-linked posts?
- Understanding conflict resolution and avoidance in PostgreSQL: a complete guide2 people · 3 mentions · first linked 2025-10-10
- PgEdge – Fully distributed PostgreSQL, optimized for the network edge2 people · 3 mentions · first linked 2023-03-07
- PgEdge Goes Open Source2 people · 2 mentions · first linked 2025-09-10
- Postgres 18: Skip Scan – Breaking Free from the Left-Most Index Limitation2 people · 2 mentions · first linked 2025-11-25
- Fully distributed PostgreSQL, optimized for the network edge2 people · 2 mentions · first linked 2023-06-14
What Hacker News says?
I did not use a script (my environment is bare metal running ubuntu 24). I read these and then wrote my own scripts that were tailored to my environment. https://pganalyze.com/blog/5mins-postgres-zero-downtime-upgr... https://www.pgedge.com/blog/always-online-or-bust-zero-downt... https://knock.app/blog/zero-downtime-postgres-upgrades Basically - Created a new cluster on new machines - Started logically replicating…
Comment linking /blog/always-online-or-bust-zero-downtime-major-version-postgres-upgrades
on “Go ahead, self-host Postgres”Submitted PgEdge Goes Open Source as a story · 126 points
HN discussionThere's a lot of ways to approach the common problems found when running multi-master / active-active PostgreSQL. (A complete guide on this, specifically using PostgreSQL in general , was written by one of our solutions engineers, Shaun Thomas: https://www.pgedge.com/blog/living-on-the-edge ) Could you elaborate on what problems you experienced?
Comment linking /blog/living-on-the-edge
on “Show HN: Open source, logical multi-master PostgreSQL replication”Submitted Understanding conflict resolution and avoidance in PostgreSQL: a complete guide as a story · 42 points
HN discussionJust a guess, but some of the undocumented edge cases you saw might be explored in this blog from one of our software engineers, Shaun Thomas. It's all about conflict resolution & avoidance in PostgreSQL, in general: https://www.pgedge.com/blog/living-on-the-edge If understanding how conflicts are handled in pgEdge is helpful, here's a link to the docs on the subject: https://docs.pgedge.com/spock_ext/conflicts And…
Comment linking /resources/faq
on “Show HN: Open source, logical multi-master PostgreSQL replication”Submitted Muhammad Aqeel: Undo for Postgres, without losing the rest of your day as a story · 24 points
HN discussionThe official FAQ has a good amount of info on how conflict resolution is handled ( https://www.pgedge.com/resources/faq )! Relevant excerpt: "pgEdge offers eventual consistency between nodes using a configurable policy (e.g. last-writer-wins) for conflict resolution, along with conflict-free delta apply columns (i.e. CRDTs) for running sum fields. This allows for independent, concurrent and eventually consistent upd…
Comment linking /blog/living-on-the-edge
on “Show HN: Open source, logical multi-master PostgreSQL replication”Submitted Simplifying Cluster-Wide PostgreSQL Execution with Exec_node() and Spock OSS as a story · 10 points
HN discussionThanks for pointing out the lack of info on conflict resolution in the README! It's been reported and we'll look at getting that updated ASAP. In the meantime, you can find a lot of information in the official FAQ on how conflict resolution is handled ( https://www.pgedge.com/resources/faq ), but at-a-glance, "pgEdge offers eventual consistency between nodes using a configurable policy (e.g. last-writer-wins) for co…
Comment linking /resources/faq
on “Show HN: Open source, logical multi-master PostgreSQL replication”Submitted PgEdge Cloud: Free multi-region distributed Postgres as a story · 10 points
HN discussionWe're a little different in that we're not just 100% open-source, but also 100% compatible with community PostgreSQL. see https://pgscorecard.com for comparisons between pgEdge and YugabyteDB, CockroachDB on that front. More thoughts on why we feel that's important here: https://www.pgedge.com/blog/considering-distributed-postgres... and the Buyer's Guide ( https://www.pgedge.com/landing-pages/distributed-postgresql…
Comment linking /landing-pages/distributed-postgresql-buyers-guide
on “PgEdge Goes Open Source”Submitted PgEdge Goes Open Source as a story · 9 points
HN discussionpgEdge came about from a pglogical foundation, actually! from one of our blogs: > pgEdge emerged in late 2024 as a serverless distributed Postgres managed cloud service, delivering low latency and high availability in three minutes or less. The pgEdge Platform (for on-premises distributed PostgreSQL) as well as pgEdge Cloud (for deploying in the cloud) was largely inspired by the original capabilities of the pgLogic…
Comment linking /blog/navigating-distributed-postgresql-options-pglogical-and-beyond
on “PgEdge Goes Open Source”Submitted Show HN: Enterprise Postgres for AI and more, from prototype to production as a story · 7 points
HN discussionInteresting read, but I find it very lacking. PGSQL memory consists of lots of parts; shared_buffers, work_mem, maintenance_work_men, OS Cache size, etc. For those who are interested in a deeper Postgresql tuning tutorial, I suggest this[1] as it highlights a number of important tuning options - specifically for PGSQL 17. Once your DB has been running for a while, run the postgresql-tuner app[2] to see if you have c…
Comment linking /blog/postgresql-performance-tuning
on “Memory Size Matters to PostgreSQL”Submitted Shaun Thomas: Burnt Toast as a story · 4 points
HN discussionpssst... we're 100% open source under the PostgreSQL license, with active-active multi-master replication for any topology from single-region HA to write-anywhere global. :-) try it out on the Downloads page on our site https://www.pgedge.com/download/enterprise-postgres for secure downloads, or check out Spock on GitHub ( https://github.com/pgEdge/spock ) and the Active Consistency Engine ( https://github.com/pgedg…
Comment linking /resources/faq
on “PgDog is funded and coming to a database near you”Submitted Postgres 18: Skip Scan – Breaking Free from the Left-Most Index Limitation as a story · 4 points
HN discussionWe use logical replication and a pause / swap in pgbouncer for ~5s of paused (but not failed) writes. This is for DBs that are ~1-1.5TB but doesnt have a huge amount of churn/qps Effectively what is described here https://www.pgedge.com/blog/always-online-or-bust-zero-downt...
Comment linking /blog/always-online-or-bust-zero-downtime-major-version-postgres-upgrades
on “PgDog is funded and coming to a database near you”Submitted PgEdge – Fully distributed PostgreSQL, optimized for the network edge as a story · 4 points
HN discussionAnother option for open source aficionados might be https://www.pgedge.com - with their spock extension they also achieve multi-master replication. Looks very interesting!
Comment linking /
on “Why PostgreSQL High Availability Matters and How to Achieve It”Submitted Show HN: Multi-Active Postgres at the Edge as a story · 4 points
HN discussionHi HN! You might be interested in pgEdge Cloud's new free offering, which includes 3 vCPU, 12 GB storage, and a 3 region cluster. This is distributed, multi-region, multi-writer PostgreSQL. The situations where our approach resonates with people the most: * Ultra-high availability for SaaS * Low-latency access, especially in multi-region scenarios * Meeting data residency requirements * Use with edge platforms like…
Comment linking /video/pgedge-cloud-developer-edition-demo
on “PgEdge Cloud: Free multi-region distributed Postgres”Submitted Using Automatic DDL Replication with PgEdge Distributed PostgreSQL as a story · 3 points
HN discussionSource code available here: https://github.com/pgedge/pgedge-northwind You can also read more about how this works in the companion blog post: https://www.pgedge.com/blog/pgedge-cloud-cloudflare-workers-...
Comment linking /blog/pgedge-cloud-cloudflare-workers-northwind-sample-app
on “Querying Distributed Postgres from Cloudflare Workers”Submitted The Long Road to Bottomless Postgres: Neon, Pg_mooncake, Pg_tier, Pg_lake as a story · 2 points
HN discussionDid you miss this: "This feature requires an AI provider to be configured in Preferences > AI." And then you have to supply an API key (see here https://www.pgedge.com/blog/ai-features-in-pgadmin-configura... ) You don't get AI for free!
Comment linking /blog/ai-features-in-pgadmin-configuration-and-reports
on “PgAdmin 4 9.13 with AI Assistant Panel”Submitted Looking Forward to Postgres 19: Checksums for All as a story · 2 points
HN discussionSubmitted Looking Forward to Postgres 19: It's About Time as a story · 2 points
HN discussionSubmitted Building AI Agents on Postgres: Why We Built the PgEdge Agentic AI Toolkit as a story · 2 points
HN discussion