Nothing here yet.
Nothing here yet.
Jul 27, 2023 路 3 min read 路 Have 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...
WCJos茅 and 1 more commented
Jul 27, 2023 路 7 min read 路 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...
BRBernardo and 1 more commented
Jul 27, 2020 路 1 min read 路 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...
Join discussion