Hacker News: pgedge_postgres

New comment by pgedge_postgres in "PgDog is funded and coming to a database near you"

pgedge_postgres — Fri, 12 Jun 2026 16:23:54 +0000

pssst... 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/pgedge/ace) to integrate the extension & tool yourself. Answers to common questions in our FAQ: https://www.pgedge.com/resources/faq#pgedge-distributed-post...

How the Other Half Counts: Planner Statistics in Oracle, Db2, MySQL, SQLite

pgedge_postgres — Wed, 10 Jun 2026 10:35:50 +0000

Article URL: https://thebuild.com/blog/how-the-other-half-counts/

Comments URL: https://news.ycombinator.com/item?id=48474256

Points: 1

# Comments: 0

PostgreSQL 19 Beta: The Four Features You'll Feel

pgedge_postgres — Mon, 08 Jun 2026 20:39:30 +0000

Article URL: https://thebuild.com/blog/postgresql-19-beta-the-four-features-youll-actually-feel/

Comments URL: https://news.ycombinator.com/item?id=48451637

Points: 3

# Comments: 0

ADHD: Parallel Divergent Ideation for Coding Agents

pgedge_postgres — Wed, 03 Jun 2026 22:30:49 +0000

Article URL: https://adhdstack.github.io/

Comments URL: https://news.ycombinator.com/item?id=48391029

Points: 4

# Comments: 2

Always Be Blaming: how Git blame answers the wrong question

pgedge_postgres — Tue, 02 Jun 2026 22:49:38 +0000

Article URL: https://matklad.github.io/2026/05/18/always-be-blaming.html

Comments URL: https://news.ycombinator.com/item?id=48377367

Points: 2

# Comments: 0

What's Easy Now? What's Hard Now? How AI Is Changing Software Development

pgedge_postgres — Mon, 01 Jun 2026 23:05:07 +0000

Article URL: https://brooker.co.za/blog/2026/05/18/whats-easy-whats-hard.html

Comments URL: https://news.ycombinator.com/item?id=48363750

Points: 5

# Comments: 1

Uncomplicating PostgreSQL management in Kubernetes- free webinar 4/14 11AM EST

pgedge_postgres — Mon, 06 Apr 2026 17:23:50 +0000

Article URL: https://us02web.zoom.us/webinar/register/WN_G1FtqK8fSe-DF3asizQ0xw

Comments URL: https://news.ycombinator.com/item?id=47663976

Points: 1

# Comments: 0

What Is a Collation, and Why Is My Data Corrupt? – PG Phridays with Shaun Thomas

pgedge_postgres — Fri, 03 Apr 2026 19:15:35 +0000

Postgres has relied on the OS to handle text sorting for most of its history. When glibc 2.28 shipped in 2018 with a major Unicode collation overhaul, every existing text index built under the old rules became invalid... but silently. No warnings, no errors. Just wrong query results and missed rows.

Postgres 17 added a builtin locale provider that removes the external dependency entirely:

initdb --locale-provider=builtin --locale=C.UTF-8

This change helps sorting to become stable across OS upgrades. glibc is still the default in Postgres 18, so this must be specified when creating a new cluster.

For clusters already running: Postgres 13+ will log a warning when a collation version changes. That warning is an instruction to rebuild affected indexes.

Get more details here in this week's PG Phriday blog post from Shaun Thomas: https://www.pgedge.com/blog/what-is-a-collation-and-why-is-my-data-corrupt

Comments URL: https://news.ycombinator.com/item?id=47630867

Points: 3

# Comments: 0

OSS MCP Server for PostgreSQL: Give Feedback and Enter to Win a Raspberry Pi

pgedge_postgres — Fri, 20 Mar 2026 14:10:20 +0000

Just 12 days left to enter to win the new CanaKit Raspberry Pi 5 Starter Kit PRO - Turbine Black, 128GB Edition and 8GB RAM (with free shipping).

We're looking for feedback on our (100% open-source) MCP Server for PostgreSQL, designed by the creator of pgAdmin (https://github.com/pgEdge/pgedge-postgres-mcp).

What works well? What would you love to see added as new features? Tell us your thoughts in the following survey link, & you'll be entered to win from there: https://pgedge.limesurvey.net/442899

Don't forget to star the repository to keep an eye out for new features - the project is under active development, and more are coming.

Giveaway ends 11:59 PM EST 3/31, winner announced 4/1!

Comments URL: https://news.ycombinator.com/item?id=47454792

Points: 2

# Comments: 0

Try an open-source MCP server for Postgres – win a Raspberry Pi

pgedge_postgres — Sun, 15 Mar 2026 09:56:06 +0000

Our MCP server for PostgreSQL is 100% open source, compatible with any new or existing installation of PostgreSQL (even variations like Amazon RDS) with fun features like... Anthropic prompt caching with 90% cost reduction Token efficiency features to stay within budget Modern React-based UI with AI-powered chat Tools like advanced hybrid search (BM25+MMR) Secure design with TLS support & more

...all from a recognized, 100% Postgres focused vendor with enterprise SLAs.

Try it out on GitHub: https://github.com/pgEdge/pgedge-postgres-mcp

To win a brand new CanaKit Raspberry Pi 5 Starter Kit PRO - Turbine Black, 128GB Edition and 8GB RAM (with free shipping), give it a try and leave us feedback here for an entry (ends March 31, winners announced April 1): https://pgedge.limesurvey.net/442899

Don't forget to leave a star to the GitHub repo to keep an eye for future releases - new features being dropped often with active development to the project.

Comments URL: https://news.ycombinator.com/item?id=47385822

Points: 1

# Comments: 0

Want to Win a New CanaKit Raspberry Pi 5 Starter Kit Pro?

pgedge_postgres — Fri, 13 Mar 2026 11:19:16 +0000

...all from a recognized, 100% Postgres focused vendor with enterprise SLAs.

Try it out on GitHub: https://github.com/pgEdge/pgedge-postgres-mcp

Don't forget to leave a star to the GitHub repo to keep an eye for future releases - new features being dropped often with active development to the project.

Comments URL: https://news.ycombinator.com/item?id=47362911

Points: 2

# Comments: 0

What questions do you have about using MCP servers with Postgres?

pgedge_postgres — Wed, 04 Feb 2026 20:21:09 +0000

What questions do you have about using MCP servers with Postgres?

We've also created an open source MCP server FOR PostgreSQL (works with any greenfield app or existing database) called pgedge-postgres-mcp (https://github.com/pgEdge/pgedge-postgres-mcp) - questions & feedback are very welcome here as well.

This February, there'll be a webinar scheduled with the engineer behind the project. He'll be answering questions, both ones asked here in this thread and ones asked at the end of the session during a Q&A.

Keep an eye out here for it to be scheduled: https://www.pgedge.com/webinars

Let's make this interesting for everyone - reply or reach out to community (at) pgedge.com if you have a question or feedback

Comments URL: https://news.ycombinator.com/item?id=46891091

Points: 3

# Comments: 1

Illinois Prairie PostgreSQL User Group Meets Feb. 18 5:30 PM CST

pgedge_postgres — Mon, 02 Feb 2026 16:44:21 +0000

If you're located near Illinois, Shaun Thomas will be presenting on "The New Postgres AI Ecosystem" at the Illinois Prairie PostgreSQL User Group this February 18th at 5:30 PM CST.

Come by the DRW and say hi: https://www.meetup.com/illinois-prairie-postgresql-user-group/events/312929674/

Comments URL: https://news.ycombinator.com/item?id=46858079

Points: 2

# Comments: 0

Pgedge-RAG-server: simple API server for RAG of text from a PostgreSQL DB

pgedge_postgres — Thu, 29 Jan 2026 14:48:20 +0000

Article URL: https://github.com/pgEdge/pgedge-rag-server

Comments URL: https://news.ycombinator.com/item?id=46810892

Points: 2

# Comments: 0

Pgedge-vectorizer: simple SQL interface for enabling vectorization in PostgreSQL

pgedge_postgres — Wed, 28 Jan 2026 19:50:16 +0000

Article URL: https://github.com/pgEdge/pgedge-vectorizer

Comments URL: https://news.ycombinator.com/item?id=46800636

Points: 1

# Comments: 0

100% open source MCP server for PostgreSQL – beta 2 out now, beta 3 on the way

pgedge_postgres — Wed, 28 Jan 2026 16:17:17 +0000

Article URL: https://www.pgedge.com/blog/what-s-new-in-the-pgedge-postgres-mcp-server-beta-2-and-beta-3

Comments URL: https://news.ycombinator.com/item?id=46797323

Points: 1

# Comments: 0

New comment by pgedge_postgres in "Free webinar 1/29: PostgreSQL 18 performance, indexing, & replication features"

pgedge_postgres — Tue, 27 Jan 2026 11:58:34 +0000

Hi! From the presenter,

> The PG 18 features that i am presenting don't directly address vector search; however asynchronous I/O can impact large vector index scan, RETURNING enhancements are useful for tracking vector insertion and updates, and generated column replication could replicate calculated embedding across distributed nodes. PostgreSQL 18 itself don't have native vector search improvements but the pgvector extension has been making significant strides in PostgreSQL 18 performance improvements which can indirectly benefit vector workloads....

Free webinar 1/29: PostgreSQL 18 performance, indexing, & replication features

pgedge_postgres — Mon, 26 Jan 2026 20:14:48 +0000

Article URL: https://us02web.zoom.us/webinar/register/WN_0235AXQERaybzWCKYHaovQ

Comments URL: https://news.ycombinator.com/item?id=46770880

Points: 1

# Comments: 2

Show HN: pgedge-loadgen for realistic open-source PostgreSQL workload simulation

pgedge_postgres — Thu, 22 Jan 2026 21:22:17 +0000

Article URL: https://github.com/pgEdge/pgedge-loadgen

Comments URL: https://news.ycombinator.com/item?id=46725281

Points: 4

# Comments: 0

New comment by pgedge_postgres in "Open-source toolkit for enterprise-ready AI development using PostgreSQL"

pgedge_postgres — Wed, 21 Jan 2026 16:08:53 +0000

We listened to customers as they refined their AI strategies in response to the rapid evolution of LLMs, Agentic AI and integration technologies such as the Model Context Protocol (MCP), and as we did so a few things stood out to us.

First and foremost, many of the newly available tools and technologies are not suited to the needs of the enterprise, particularly in highly regulated industries or major government agencies. Many of the new AI application builders and code generators – and the database platforms supporting them – do not adequately address enterprise requirements for high availability, data sovereignty, global deployment, security and compliance and the need in some cases to run on-premises or in self-managed cloud accounts. As one CIO from a large financial services firm put it to us recently: “We’ve got a couple of dozen AI generated applications end users really want to put into production, but first we’ve got to figure out how to deploy them on our own internal compliant infrastructure.”

Secondly, as compelling as it is to automate workflows with Agentic AI, or to generate new applications with tools like Claude Code, Replit, Cursor or Lovable, the biggest need is to work with existing databases and applications. While some of the newer Postgres-based cloud services work well with Agentic AI and AI app builders for brand new applications they cannot accommodate existing databases and applications without a costly migration – and perhaps to an environment that doesn’t meet the organization’s strict security and compliance requirements. Enterprise customers need AI tooling – including an MCP Server – that can operate against their existing databases.

Additionally we saw there was no dedicated Postgres vendor offering a fully featured and fully supported MCP Server that works with all your existing Postgres databases. Most of the available Postgres MCP Servers are tied to the vendor's own products, and in particular their cloud database offering.

And thirdly, developing new AI applications such as a chatbot running on top of an existing knowledge base, is overly complex with developers having to stitch together too many tools, APIs, Postgres extensions and data pipelines. We saw an opportunity to make it easier to develop AI applications without having to undertake a major exercise in tool sourcing and integration.

We are addressing each of these with the pgEdge Agentic AI Toolkit for Postgres.