#sql - Frag's blog

Skip to main content

Hashnode Frag's blog

Command Palette

Search for a command to run...

#sql

Articles tagged with #sql

Mastering PostgreSQL Table Partitioning
Table 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...
Jul 27, 20237 min read7.2K
Howto: drop Postgres tables matching a pattern
Suppose 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...
Jul 27, 20201 min read983

© 2026 Frag's blog

Members
Archive
Privacy
Terms