Menu

#PostGres

322 posts

Feed·
20 of 322 posts
I followed Keploy's quickstart as a first-time user. Here's where it broke.
🖼️
0Read More

I followed Keploy's quickstart as a first-time user. Here's where it broke.

DEV Community: go·VidhiDixit2000·about 9 hours ago
#2b7OusxY
#devtogo#devto#dev#test#keploy

A couple of months ago I came across a product called Keploy on LinkedIn. I went to their site to...

15s
Postgres Full-Text Search vs Elasticsearch vs Meilisearch: BM25 Benchmarked (2026)
📰
0Read More

Postgres Full-Text Search vs Elasticsearch vs Meilisearch: BM25 Benchmarked (2026)

DEV Community: postgres·Waseem Anjum·about 21 hours ago
#Jqv4Vsqb

BM25 in Postgres (pg_search, pg_textsearch) matched Elasticsearch on 3 BEIR datasets and made new rows searchable in ms. tsvector and Meilisearch lagged.

15s
How We Cut Postgres p95 Latency from 914ms to 2ms (Serverless vs. Docker + PgBouncer)
📰
0Read More

How We Cut Postgres p95 Latency from 914ms to 2ms (Serverless vs. Docker + PgBouncer)

DEV Community: node·Anwar Iqbal Dawar·3 days ago
#EjKd3Caf
#devtonodejs#devto#dev#pgbouncer#serverless

Breaking down where our 914ms p95 database latency actually went, what same-region tuning fixed (9ms), and how co-located PostgreSQL 18 + PgBouncer 1.26 brought it down to 2ms.

15s
Cheapest way to host a web app with Postgres in 2026: seven platforms priced
📰
0Read More

Cheapest way to host a web app with Postgres in 2026: seven platforms priced

DEV Community: cloud·Abhishek Jaiswal·4 days ago
#O7aFK4yx
#devtocloud#devto#dev#ownkube#database

One web app, one Postgres database and one cache, priced on Ownkube, Northflank, DigitalOcean, Railway, Fly.io, Render and Heroku, with the idle and busy cases.

15s
Heroku alternatives in 2026: five options compared, with real dyno math
🖼️
0Read More

Heroku alternatives in 2026: five options compared, with real dyno math

DEV Community: cloud·Abhishek Jaiswal·4 days ago
#EWDWcKIf
#devtocloud#devto#dev#heroku#month

The Heroku alternatives developers pick in 2026 (Ownkube, Render, Railway, Fly.io, DigitalOcean), a small production stack priced on each, and when to stay.

15s
Two Postgres clients, one database, and the only option they agree on is the one the pooler forces
📰
0Read More

Two Postgres clients, one database, and the only option they agree on is the one the pooler forces

DEV Community: nextjs·Daniel Pertu·5 days ago
#hUy0bOao
#devtonextjs#devto#dev#client#postgres

Our serverless half opens one connection and drops it the instant it goes idle. Our long-running half opens ten and keeps them for half an hour. Same database, opposite settings, and one shared warning comment.

15s
Building RAG on PostgreSQL with Pgvector and Ruby on rails
🖼️
0Read More

Building RAG on PostgreSQL with Pgvector and Ruby on rails

DEV Community: ruby·A.Talaat·6 days ago
#YyXo1ymA
#devtoruby#devto#dev#vector#database

🧠 Your Database Is Already a Vector Database Most RAG tutorials start the same way: "First, spin up...

15s
Under the hood, off the hot path: how D1 scales to millions of databases
🖼️
0Read More

Under the hood, off the hot path: how D1 scales to millions of databases

#cloudflare#database#durable#postgres#query

A deep dive into how D1 architected its control plane to scale and manage millions of databases, while keeping data plane query operations at the edge. We share guiding principles on how to build on the Developer Platform effectively.

15s
Postgres SELECT DISTINCT Does Not Scale
🖼️
106Read More

Postgres SELECT DISTINCT Does Not Scale

Hacker News·about 1 month ago
#me6pRzQt
#dbos#postgres#sql#photo#article

Postgres SELECT DISTINCT performs surprisingly poorly. We explain why and how we mitigated it.

15s
Training a 4B model to produce 81% faster query plans than Postgres
📰
0Read More

Training a 4B model to produce 81% faster query plans than Postgres

Hacker News·about 1 month ago
#ut6JOjZ2
#rohanbansal#postgres#grpo#article#ama

...or how to make Qwen learn query optimization via agentic reinforcement learning

15s
Rebuilding Postgres for 300x faster analytics: batching, operator fusion, and SIMD - malisper.me
🖼️
338Read More

Rebuilding Postgres for 300x faster analytics: batching, operator fusion, and SIMD - malisper.me

Hacker News·3 months ago
#dY5qNdKt
#malisper#query#self#postgres#table

Last week we released version 0.2 of pgrust. This release was all about performance. It’s 10x faster than the previous version of pgrust. On OLTP benchmarks, pgrust is 30% faster than Postgres, and on Clickbench, Clickhouse’s benchmark for analytical…

15s
Postgres LISTEN/NOTIFY Actually Scales
🖼️
0Read More

Postgres LISTEN/NOTIFY Actually Scales

Hacker News·3 months ago
#Gc5q3tUp
#dbos#postgres#notifications#stream#notify

How we optimized Postgres LISTEN/NOTIFY-backed data streams at scale, achieving 60K writes per second with millisecond latency.

15s