MCMatteo Crostainfragland.dev路Jul 27, 2023 路 3 min readAll You Need to Know About UUIDsHave you ever been curious about what UUIDs can really do? 馃槸 Maybe you've seen them around before, like when you're trying to keep track of information in a database, but have you ever stopped to think about their full potential? This article is he...02WC
MCMatteo Crostainfragland.dev路Jul 27, 2023 路 7 min readMastering PostgreSQL Table PartitioningTable partitioning is a highly effective technique used to improve the performance of very large database tables. By dividing the table's content into smaller sub-tables, known as partitions, the overall size of the table is reduced, leading to signi...02BR
MCMatteo Crostainfragland.dev路Jul 27, 2020 路 1 min readHowto: drop Postgres tables matching a patternSuppose that your database has lots of tables, with similar names (maybe partitions of a bigger table?), here's a quick way to drop them in bulk SELECT 'drop table '||n.nspname ||'.'|| c.relname||';' as "Name" FROM pg_catalog.pg_class c LEFT JO...00
