1861
Benchmarking Postgres 17 vs. 18
Postgres 18 brings a significant improvement to read performance via async I/O and I/O worker threads. Here we compare its performance to Postgres 17.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
1862
Optimistic Locking in B-Trees
CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools and tomorrow’s challenges.
1863
How to Become a Data Scientist, Part 2
This is Part Two in a three-part series examining how to become a data scientist. Supported by extensive research and expert opinions, it aims to provide a comprehensive guide to anyone looking to move into this field, irrespective of background and experience. The topic of Part Two is: "Learning".
1864
The Case of a Curious SQL Query
Languages that suffer success often have to do so by selling out and adding features that go against some of the original purposes of their design. SQL is a...
1865
Parallel Commits: A New Atomic Commit Protocol for Distributed Transactions
Parallel Commits are an atomic commit protocol in CockroachDB. The feature promises to halve the latency of distributed transactions by performing all consensus round trips required to commit a transaction concurrently.
1866
1867
Two Bits Are Better Than One: making bloom filters 2x more accurate
Optimisation of bloom filters in Floe using double bit setting with lightweight hashing.
1868
1869
Jepsen: Dgraph 1.0.2
2019-04-10: The long fork test used in this analysis contained a bug which caused it to (in many cases) fail to identify long fork anomalies—though we did find instances of long fork using other tests. We have re-checked Dgraph 1.0.13 with a corrected checker, and its long fork tests still pass.
1870
When to Avoid JSONB in a PostgreSQL Schema
Heap is the only digital insights platform that shows everything users do on your site, revealing the "unknown unknowns" that stay invisible with other tools.
1871
1872
1873
Polars Cloud and Distributed Polars now available
We launch Polars Cloud; the distributed Cloud Architecture to run Polars anywhere
1874
New ScyllaDB Go Driver: Faster Than GoCQL and Its Rust Counterpart
How we built a new Go ScyllaDB driver that’s almost 4x faster than its GoCQL predecessor and 2X faster than its Rust counterpart.
1875
How to beat the CAP theorem
The CAP theorem states a database cannot guarantee consistency, availability, and partition-tolera...
1876
Zombie stats: Where the numbers AI quotes come from
We asked five AI assistants 200 questions that call for a number and followed 1,285 of the statistics they cited back to the source.
1877
Why Are Geospatial Databases So Hard to Build?
In 2005, I decided to design my first geospatial database engine. PostGIS was unable to keep up with the modest volumes of sensor data I was working with and while I was new to geospatial data, I had skill designing database engines. It seemed simple enough to get the scale and performance I required. Nothing could…
1878
1879
1880
Data Mining Hacker News: Front vs. Back
Using Haskell, R, Python, SQLite, and Elasticsearch, we data mine Hacker News front page stories and their back page counterparts for patterns.
1881
1882
Backblaze Drive Stats for Q1 2022
Backblaze wants to be as transparent as possible with our customers about our business. Here’s what you need to know about our drives in Q1 2022.
1883
Using PostgreSQL for military geoanalytics tasks
My name is Taras Kloba, Chief Partner Architect at Microsoft. This blog captures my journey through data engineering, certifications, and technology insights.
1884
1885
1886
Oldest recorded transaction
The oldest recorded transaction was in 3100 BC
1887
1888
Visualizing data is an art
The case for less rigor and more nuance.
1889
Postgres data stored in Parquet on S3: LTAP architecture explained
Almost every traditional database keeps its write-ahead log and data files on one machine's disk, which is the root cause of data loss risk, expensive read replicas and high-availability clones, and analytics queries that drag down transactions.
1890
The surprising impact of medium-size texts on PostgreSQL performance
Why TOAST is the best thing since sliced bread