GoKawiil - Latest Tech News & Aggregated Headlines

PostgreSQL Maintenance Without Superuser

news.ycombinator.com Radim Marek 2025-09-20 01:17:29

How many people/services have superuser access to your PostgreSQL cluster(s)? Did you ever ask why your software engineers might need it? Or your BI team? Why those use cases require same privileges as someone who can drop your databases? The answer isn't because these operations are inherently dangerous - it's because PostgreSQL historically offered limited options for operational access or simply because not enough people are aware of the options. So the common practice is to either got basic

Topics: access grant postgresql role roles

Shop Amazon

Pgstream: Postgres streaming logical replication with DDL changes

news.ycombinator.com Unknown 2025-10-01 03:28:24

pgstream - Postgres replication with DDL changes pgstream is an open source CDC command-line tool and library that offers Postgres replication support with DDL changes to any provided target. Features Schema change tracking and replication of DDL changes Support for multiple out of the box targets Elasticsearch/OpenSearch Webhooks PostgreSQL Initial and on demand PostgreSQL snapshots (for when you don't need continuous replication) Column value transformations (anonymise your data on the g

Topics: configuration pgstream postgres run using

Shop Amazon

PgEdge Goes Open Source

news.ycombinator.com Dave Page 2025-10-06 03:01:57

In November last year after nearly two decades at my previous gig, I came to the conclusion that I didn’t want to work at what seemed to be rapidly becoming an AI-focused company and moved to pgEdge where the focus is well and truly on distributed PostgreSQL and Postgres generally. Distributed databases (and particularly Postgres of course) have always been a passion of mine – even being a key topic of my master’s dissertation many years ago. Moving to pgEdge was a breath of fresh air. Not only

Topics: distributed pgedge postgres postgresql source

Shop Amazon

PG Auto Upgrade – Docker (and K8s) container to auto upgrade your database

news.ycombinator.com Unknown 2025-11-16 23:10:30

pgautoupgrade This is a PostgreSQL Docker image to automatically upgrade your database. Its whole purpose in life is to automatically detect the version of PostgreSQL used in the existing PostgreSQL data directory, then automatically upgrade it (if needed) to the required version of PostgreSQL using pg_upgrade with the --link option. After this, the PostgreSQL server starts and runs as per normal. The old cluster data will be removed. The reason this Docker image is needed, is because the of

Topics: data docker image pgautoupgrade postgresql

Shop Amazon

ClickHouse matches PG for single-row UPDATEs and 4000 x faster for bulk UPDATEs

news.ycombinator.com Unknown 2025-11-18 10:52:43

TL;DR · On identical hardware and data, ClickHouse matches PostgreSQL for single-row UPDATEs and is up to 4,000× faster in our tests for bulk UPDATEs. · Why it matters: Bulk updates are common in OLTP workloads, and ClickHouse’s columnar design + parallelism make them far faster. · Caveat: PostgreSQL is fully transactional by default; ClickHouse isn’t. Results compare each engine’s native execution model, not identical transaction guarantees. PostgreSQL is the most popular open-source

Topics: clickhouse data postgresql update updates

Shop Amazon

Neki – Sharded Postgres by the team behind Vitess

news.ycombinator.com Unknown 2025-11-27 18:03:57

Announcing Neki By Andres Taylor, Dirkjan Bussink, Harshit Gangal, Nick Van Wiggeren, Noble Mittal, Rohit Nayak, Roman Sodermans, Shlomi Noach, Sam Lambert | August 11, 2025 Today, we are announcing Neki — sharded Postgres by the team behind Vitess. Vitess is one of PlanetScale’s greatest strengths and contemporary Vitess is the product of our experience running at extreme scale. We have made explicit sharding accessible to hundreds of thousands of people and it is time to bring this power to

Topics: announcing neki postgres scale vitess

Shop Amazon

Neki – sharded Postgres by the team behind Vitess

news.ycombinator.com Unknown 2025-11-30 12:03:57

Announcing Neki By Andres Taylor, Dirkjan Bussink, Harshit Gangal, Nick Van Wiggeren, Noble Mittal, Rohit Nayak, Roman Sodermans, Shlomi Noach, Sam Lambert | August 11, 2025 Today, we are announcing Neki — sharded Postgres by the team behind Vitess. Vitess is one of PlanetScale’s greatest strengths and contemporary Vitess is the product of our experience running at extreme scale. We have made explicit sharding accessible to hundreds of thousands of people and it is time to bring this power to

Topics: announcing neki postgres scale vitess

Shop Amazon

Build durable workflows with Postgres

news.ycombinator.com Unknown 2025-12-02 17:24:07

When we started building a durable workflows library, the most critical architectural decision we faced was what data store to use for workflow metadata. The core durable workflow operations are simple–checkpointing workflow state and recovering an interrupted workflow from its latest checkpoint. Almost any data store can handle these operations, but choosing the right one is critical to ensure workflows are scalable and performant. In this blog post, we’ll dive deep into why we chose to build

Topics: durable postgres step workflow workflows

Shop Amazon

Making Postgres slower

news.ycombinator.com Jacob Jackson 2025-12-28 22:12:59

July 27, 2025 Everyone is always wondering how to make Postgres faster, more efficient, etc, but nobody ever thinks about how to make Postgres slower. Now, of course, most of those people are being paid to focus on speed, but I am not (although, if you wanted to change that, let me know). As I was writing a slightly more useful guide, I decided someone needed to try to create a Postgres configuration optimized to process queries as slowly as possible. Why? I am not sure, but this is what came o

Topics: 00 pages postgres usage wal

Shop Amazon

We made Postgres writes faster, but it broke replication

news.ycombinator.com Unknown 2026-01-10 23:26:04

We Made Postgres Writes Faster, but it Broke Replication +2 By Stu Hood, Ming Ying, Mathew Pregasen, and Olive Ratliff on June 30, 2025 When we built pg_search , the Postgres extension for search and analytics, write throughput was a priority. To be an effective alternative to Elasticsearch we needed to support high ingest workloads in real time. This is because many Elasticsearch use cases — like real-time dashboards, e-commerce search, and recommendation systems — involve continuous writes t

Topics: consistency data postgres primary tuple

Shop Amazon

Show HN: OrioleDB Beta12 Features and Benchmarks

news.ycombinator.com Unknown 2026-01-07 08:22:33

Since our last public update, OrioleDB has continued to evolve with a series of new releases. These updates refine the core engine, extend functionality, and improve performance across a range of workloads. Together, they move us closer to a beta release and lay the groundwork for broader adoption. OrioleDB is a PostgreSQL storage extension that implements a custom Table Access Method as a drop‑in replacement for the default Heap storage engine. It is designed to address scalability bottlenecks

Topics: 000 orioledb postgres tables tpc

Shop Amazon

ParadeDB takes on Elasticsearch as interest in Postgres explodes amid AI boom

techcrunch.com Rebecca Szkutak 2026-01-22 03:24:51

Open source database management system Postgres is nearly 40 years old, but has recently started seeing explosive demand due to being very well-suited for AI applications. Despite this rise in popularity, search and analytics functionality remain limited. ParadeDB is changing that. ParadeDB is an open source Postgres extension that facilitates full-text search and analytics directly in Postgres without users needing to transfer data to a separate source. The platform integrates with other data

Topics: data noël paradedb postgres said

Shop Amazon

When Sigterm Does Nothing: A Postgres Mystery

news.ycombinator.com Unknown 2026-01-22 16:43:08

In my opinion, the worst bugs are the ones you decide not to look further into. Maybe the problem only manifests 2% of the time, or when you run the code on a particular brand of toaster. Maybe the customer doesn't supply enough information to begin narrowing down the cause. Maybe you just don't have enough time to track the issue down fully. And everyone eventually moves on. But when you see the same bug strike again months later, you quietly mutter to yourself and wish you'd been persistent

Topics: postgres read slot transaction transactions

Shop Amazon

Postgres LISTEN/NOTIFY does not scale

news.ycombinator.com Unknown 2026-01-24 20:05:06

At Recall.ai, we run an unusual workload. We record millions of hours of meetings every month. Each of these meetings generates a large amount of data we need to reliably capture and analyze. Some of that data is video, some of it is audio and some of it is structured data – transcription, events and metadata. The structured data gets written to our Postgres database by tens of thousands of simultaneous writers. Each of these writers is a “meeting bot”, which joins a video call and captures the

Topics: 03 database lock notify postgres

Shop Amazon

PlanetScale for Postgres

news.ycombinator.com Unknown 2026-02-17 10:08:29

Announcing PlanetScale for Postgres By Sam Lambert | July 1, 2025 Today we are announcing the private preview of PlanetScale for Postgres: the world’s fastest Postgres hosting platform. You can request access to PlanetScale for Postgres by visiting this link. We are already hosting customers' production workloads with incredible results. Convex, the complete backend solution for app developers, is migrating their reactive database infrastructure to PlanetScale for Postgres. Read more about t

Topics: hosting performance planetscale postgres vitess

Shop Amazon

Benchmarking Postgres

news.ycombinator.com Unknown 2026-02-17 17:31:02

Want to learn more about unlimited IOPS w/ Metal, Vitess, horizontal sharding, or Enterprise options? Benchmarking Postgres By Benjamin Dicken | July 1, 2025 Today we launched PlanetScale for Postgres. For the past several months, we've been laser focused on building the best Postgres experience on the planet, performance included. To ensure we met our high standard for database performance, we needed a way to measure and compare other options with a standardized, repeatable, and fair method

Topics: benchmark database latency planetscale postgres

Shop Amazon

Show HN: SnapQL – Desktop app to query Postgres with AI

news.ycombinator.com Unknown 2026-03-08 21:08:18

SnapQL cursor for data ⚡️ - explore your postgresql db in seconds demo.mp4 generate schema-aware queries in seconds with AI supports any PostgreSQL database fully local desktop app use your own OpenAI key Build SnapQL locally I will eventually ship some precompiled binaries, but that takes some setup. In the meantime, follow these steps to build a local copy:

Topics: build local postgresql seconds snapql

Shop Amazon

Timescale Is Now TigerData

news.ycombinator.com Unknown 2026-03-13 18:58:14

Learn how to make PostgreSQL faster with our documentation AI and Vector Learn how to use PostgreSQL for Al with our documentation

Topics: ai documentation faster learn postgresql

Shop Amazon

Latest Tech News

PostgreSQL Maintenance Without Superuser

Pgstream: Postgres streaming logical replication with DDL changes

PgEdge Goes Open Source

PG Auto Upgrade – Docker (and K8s) container to auto upgrade your database

ClickHouse matches PG for single-row UPDATEs and 4000 x faster for bulk UPDATEs

Neki – Sharded Postgres by the team behind Vitess

Neki – sharded Postgres by the team behind Vitess

Build durable workflows with Postgres

Making Postgres slower

We made Postgres writes faster, but it broke replication

Show HN: OrioleDB Beta12 Features and Benchmarks

ParadeDB takes on Elasticsearch as interest in Postgres explodes amid AI boom

When Sigterm Does Nothing: A Postgres Mystery

Postgres LISTEN/NOTIFY does not scale

PlanetScale for Postgres

Benchmarking Postgres

Show HN: SnapQL – Desktop app to query Postgres with AI

Timescale Is Now TigerData

About GoKawiil

Privacy

Advertising

Latest Tech News

Trending Topics

Hot Now

Popular

Emerging

About GoKawiil

Privacy

Advertising