31
Zero downtime Postgres upgrades
How we upgraded from Postgres 11.9 to 15.3 with zero downtime
Most cited
Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 47 posts.
32
33
Skip the API, ship your database
The best code is the code unwritten. Avoid building a complex API layer by sharing your database between services.
34
How RocksDB Works
Over the past years, the adoption of RocksDB increased dramatically. It became a standard for embeddable key-value stores.
35
What are embeddings?
A deep-dive into machine learning embeddings.
36
Gzip beats BERT? Part 2: dataset issues, improved speed, and results
Summary : Update to my last post analyzing the gzip+knn paper. Some of the datasets have heavily contaminated train/test tests. I show some ways to significantly speed-up the gzip method. I present more results of my "fair" reimplementation .
37
BigQuery prices increasing by more than 100% for many users
New BigQuery pricing editions and autoscaling let you choose the right price-performance for your workloads, and pay for only what you use.
38
Unexpected downsides of UUID keys in PostgreSQL
Understand how using UUIDs as primary keys can affect PostgreSQL performance, and how to tweak your index to avoid UUID performance pitfalls.
39
PgBouncer is useful, important, and fraught with peril
Updated 2024-09-17 to reflect updated PgBouncer support for protocol-level prepared statements 🐘 To start, I want to say that I’m appreciative that PgBouncer exists and the work its open source maintainers put into it. I also love working with PostgreSQL, and I’m thankful for the incredible amount of work and…
40
SQLite performance tuning: concurrent reads, multiple GBs and 100k SELECTs/s
SQLite is an embedded SQL database. It’s extremely easy to setup, buildable as a single C file with libraries existing for basically all common programming languages. It doesn’t need any server setup or configuration since the SQL logic is run in the host process, and the database consists of only
41
Pg_jsonschema – JSON Schema Support for Postgres
Today we're releasing pg_jsonschema, a Postgres extension for JSON validation.
42
Polars: Company Formation Announcement
We are excited to announce the start of company that will build around Polars, enabling data processing at any scale.
43
S3 Express Is All You Need
The future of modern data infrastructure is object storage.
44
There have been 562 bank failures since 2000
One way to measure the magnitude of a bank's failure is by the amount of assets the bank held. At the time it failed, SVB's collapse was the second largest American bank failure of all time, and the largest since 2008.
45
Querying the GitHub archive with the ClickHouse playground
Via this comment on Hacker News I started exploring the ClickHouse Playground . It's really cool, and among other things it allows CORS-enabled API hits that can query a decade of history from the GitHub events archive in less than a second.
46
Apache Hudi vs. Delta Lake vs. Apache Iceberg Lakehouse Feature Comparison
A thorough comparison of the Apache Hudi™, Delta Lake, and Apache Iceberg™ data lakehouse projects across features, community, and performance benchmarks. This includes a focus on common use cases such as change data capture (CDC) and data ingestion.
47
20x faster than pgvector: HNSW index in Postgres with pg_embedding
We’re excited to announce the release of our pg_embedding extension for Postgres and LangChain! The new pg_embedding extension brings 20x the speed for 99% accuracy to graph-based approximate nearest neighbor search to your Postgres databases. While the pgvector extension with IVFFlat indexing has been a popular…