Tag: databases
All the articles with the tag "databases".
One index, 467x faster: reading a PostgreSQL B-tree from the inside
Five million rows, one customer, 54 ms with a sequential scan and 0.116 ms with a B-tree index. The EXPLAIN output line by line, the tree's real depth from pageinspect, what the index costs, and every command to repeat it.
Repeating MotherDuck's DuckDB 2.0 benchmarks on my own laptop
Three tests from the article 'Why DuckDB 2.0 is faster', run again on DuckDB 1.5.5 and the 2.0 alpha: a Parquet file on S3, a recursive query, and JSON stored as VARIANT. With the SQL, the output, and the one query that got slower.
