🎁 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

Database Sharding
A horizontal scaling strategy that distributes data across multiple database servers based on a partition key.
Materialized View
A database object that stores the precomputed result of a query, offering faster reads at the cost of periodic refresh.
Foreign Key
A column that creates a link between two tables by referencing the primary key of another table.
EXPLAIN Plan
A database command that shows how the query planner will execute a SQL query, revealing join methods, scan types, and estimated costs.
NoSQL
A category of databases that store data in non-tabular formats, optimized for specific data models and access patterns.
MVCC (Multi-Version Concurrency Control)
A technique where the database maintains multiple versions of data to allow concurrent reads and writes without locking.
 View All Databases Terms →