#sql
How fast DuckDB can query Parquet files?
Querying daily Parquet files of web logs with DuckDB on an M1 Mac: a top-pages aggregation in 0.07 s and a full ZSTD Parquet rewrite in 4.9 s.
Creating partitions automatically in PostgreSQL
Splitting a large PostgreSQL table into daily partitions with a PL/pgSQL trigger that creates each partition on first insert, using table inheritance.