Updated
Postgres
SQL
DO $$
DECLARE
r RECORD;
BEGIN
FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = 'public')
LOOP
EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(r.tablename) || ' CASCADE';
END LOOP;
END $$;drops all tables in db (resets db)
Links
🚨 PostgreSQL 18 Beta is here 🚨
Highlights:
⚡️ Async I/O (with io_uring) — 2–3x speedups on seq scans, vacuums
🔍 Skip scan + smarter OR/IN optimizations
🔄 Keep planner stats during major upgrades
🧬 uuidv7() and virtual generated columns
🔐 OAuth login
📊 EXPLAIN
https://lobste.rs/s/oj3ce4/kafka_is_fast_i_ll_use_postgres
https://www.cybertec-postgresql.com/en/super-fast-aggregations-in-postgresql-19/