#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 read963

#sql - Frag's blog