๐ŸŽ New User? Get 20% off your first purchase with code NEWUSER20 ยท โšก Instant download ยท ๐Ÿ”’ Secure checkout Register Now โ†’
Menu

Categories

Databases Advanced

What is Partitioning?

A technique of dividing large database tables into smaller, more manageable segments while maintaining a single logical table.

Table partitioning splits large tables into smaller physical pieces based on a partition key. Types include range partitioning (by date ranges), list partitioning (by category values), and hash partitioning (even distribution).

Benefits include faster queries on partitioned columns (partition pruning), easier data maintenance (drop old partitions), and parallel query execution. PostgreSQL supports declarative partitioning since version 10.

Related Terms

Row-Level Security (RLS)
A database feature that restricts which rows a user can access in a table based on security policies.
Graph Database
A database that uses graph structures with nodes, edges, and properties to store and query highly connected data.
Schema
The structure definition of a database including tables, columns, data types, relationships, indexes, and constraints.
B-Tree Index
The default index type in most databases that organizes data in a balanced tree structure for efficient searching, sorting, and range queries.
EXPLAIN Plan
A database command that shows how the query planner will execute a SQL query, revealing join methods, scan types, and estimated costs.
Write-Ahead Log (WAL)
A technique where changes are first written to a log before being applied to the database, ensuring crash recovery and data integrity.
View All Databases Terms โ†’