2761
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...
New
The latest blog posts to take off on Hacker News. 4,224 posts.
2762
2763
Hazelcast 3.8.3
2017-10-07: IMap is not the only datatype supporting merge: ICache is mergable as well.
2764
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.
2765
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 …
2766
PostgreSQL 10 Released
The PostgreSQL Global Development Group today announced the release of PostgreSQL 10, the latest version of the world's most advanced …
2767
2768
2769
A Decade of Dynamo
Today marks the 10-year anniversary of Amazon's Dynamo. Here are some reflections on ten years of NoSQL databases
2770
2771
2772
2773
Wikipedia graph mining: dynamic structure of collective memory
Wikipedia graph dynamic pattern discovery. Dynamic graph analysis in GraphX. Collective memory research. Gephi graph visualization.
2774
Visualizing Your Ruby Heap
In a previous post, I wrote a bit about how Ruby objects are laid out in memory. Today we’ll use that information to write a program that will allow us to take a Ruby heap dump and visualize the layout and fragmentation of that heap. Ruby Object Layout Recap Just as a recap, Ruby objects are fixed width. That is…
2775
Stream VByte: breaking new speed records for integer compression
In many information systems, we work with arrays of integers. For example, maybe you need to keep track of which records in a database contain a given value. This sort of mapping can be expressed as an array of integers. These arrays can end up taking up a large fraction of your memory or disk … Continue reading…
2776
On Disk IO, Part 3: LSM Trees
If you like the series, check out my book on Database Internals!
2777
2778
Open-Sourcing Vespa, Yahoo’s Data Processing and Serving Engine
Yahoo, the trusted guide for millions globally with iconic products for 30+ years—offers advertisers omnichannel solutions and powerful data to deliver results.
2779
PostgreSQL's Hash Indexes Are Now Cool
Since I just committed the last pending patch to improve hash indexes to PostgreSQL 11, and since most of the improvements to hash indexes w...
2780
When Citi Bikes Are Faster Than Taxis in New York City
Over 50% of peak hour taxi trips would be faster as Citi Bike rides, and taxis are only getting slower
2781
Why SQL is beating NoSQL, and what this means for the future of data
After being left for dead, SQL is making a comeback and the NoSQL vs. SQL debate is stronger than ever. Why? And how will it impact the data community?
2782
Apache Arrow and the “Things I Hate About Pandas”
This post is the first of many to come on Apache Arrow, pandas, pandas2, and the general trajectory of my work in recent times and into the foreseeable future. This is a bit of a read and overall fairly technical, but if interested I encourage you to take the time to work through it.
2783
2784
APFS – A Backup Software Developer’s Perspective
A backup-software developer's deep dive into Apple's APFS file system — snapshots, cloning, space sharing, and what it all means for reliable Mac backups.
2785
2786
Transactionally Staged Job Drains in Postgres
Building a robust background worker system that leverages transactional isolation to never work a job too early, and transactional durability to never let one drop.
2787
Spaces: Scalable Object Storage on DigitalOcean
Helping millions of developers easily build, test, manage, and scale applications of any size - faster than ever before.
2788
Index Investing Makes Markets and Economies More Efficient (2016)
U.S. equity index funds have grown dramatically in recent decades, from a negligible $500MM in assets in the early 1980s to a staggering $4T today. The consensus view in the investment community is that this growth is unsustainable. Indexing, after all, is a form of free-riding, and a market can only support so many…
2789
Getting Started on Geospatial Analysis with Python, GeoJSON and GeoPandas
Learn to perform the basics of geospatial analysis using Python along with the GeoJSON and GeoPandas libraries.
2790
Prime Day 2017: 12.9M DynamoDB requests per second
The third annual Prime Day set another round of records for global orders, topping Black Friday and Cyber Monday, making it the biggest day in Amazon retail history. Over the course of the 30 hour event, tens of millions of Prime members purchased things like Echo Dots, Fire tablets, programmable pressure cookers…