61
Hard Drive Stats for Q3 2017
We take a look at the performance of our 86,529 hard drives and break down the failure rates by manufacturer and model size.
New
The latest blog posts to take off on Hacker News. 332 posts.
62
Amazon Aurora with PostgreSQL Compatibility
Late last year I told you about our plans to add PostgreSQL compatibility to Amazon Aurora. We launched the private beta shortly after that announcement, and followed it up earlier this year with an open preview. We’ve received lots of great feedback during the beta and the preview and have done our best to make […]
63
64
65
Getting the Most Out of Sqlite3 with Python
Simplex Sigillum Veri
66
67
Word vectors are awesome but you don’t need a neural network to find them
When I started playing with word2vec four years ago I needed (and luckily had) tons of supercomputer time. But because of advances in our understanding of w...
68
69
70
Efficient pagination of a SQL table with 100M records
Compilation of my favorite SQL queries after a decade of dealing with relational databases. Today we talk about scanning a table with 100 million records.
71
72
Unbalanced reads from SSDs in software RAID mirrors in Linux
You're probably reading this page because you've attempted to access some part of my blog (Wandering Thoughts) or CSpace , the wiki thing it's part of. Unfortunately you're using a browser version that my anti-crawler precautions consider suspicious, most often because it's too old (most often this applies to versions…
73
Analysing C# code on GitHub with BigQuery
Just over a year ago Google made all the open source code on GitHub available for querying within BigQuery and as if that wasn’t enough you can run a terabyte of queries each month for free!
74
Dear Postgres
Dear Postgres, I’ve always felt an affinity for you in my 9 years of working with you. I know others have known you longer, but that doesn’t mean they love you more. Years ago when others complained about your rigidness or that you weren’t as accommodating as others I found solace in your steadfast values: Don’t lose…
75
CockroachDB 1.1 Released: Production Made Easy
CockroachDB 1.1 includes support for faster migrations from legacy databases, simplified cluster management, and improved performance.
76
77
Ways to paginate in Postgres (2016)
Pagination, pervasive as it is in web applications, is easy to implement inefficiently. This post examines different methods of server-side pagination and their tradeoffs in PostgreSQL. Methods explored include limit-offset, cursors, keyset pagination, as well as more exotic techniques.
78
A Data-Driven Guide to Becoming a Consistent Billionaire
Did You Really Think All Billionaires Were the Same? Recently, I became a bit obsessed with the one percent of the one percent – Billionaires. I was intrigued when I stumbled on articles telling us…
79
80
How I Reduced My DB Server Load by 80%
Database load can be a silent performance killer. I’ve been optimizing the query performance of a web app I run designed to get people involved in open sourc...
81
82
Hazelcast 3.8.3
2017-10-07: IMap is not the only datatype supporting merge: ICache is mergable as well.
83
I/O Access Methods for Linux
Explore the four different ways to perform disk I/O on Linux and the tradeoffs and what we chose for ScyllaDB to build a high-performing database.
84
Implementing faceted search with Django and PostgreSQL
I’ve added a faceted search engine to this blog, powered by PostgreSQL. It supports regular text search (proper search, not just SQL“like” queries), filter by tag, filter by date, filter …
85
PostgreSQL 10 Released
The PostgreSQL Global Development Group today announced the release of PostgreSQL 10, the latest version of the world's most advanced …
86
87
88
A Decade of Dynamo
Today marks the 10-year anniversary of Amazon's Dynamo. Here are some reflections on ten years of NoSQL databases
89
90
