🎁 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

Transaction
A sequence of database operations that are treated as a single unit — either all succeed or all are rolled back.
SQL
Structured Query Language — the standard language for managing and querying data in relational databases.
EXPLAIN ANALYZE
A PostgreSQL command that shows the execution plan of a query along with actual runtime statistics for performance tuning.
Full-Text Search
A technique for searching natural language text in databases using word stemming, ranking, and relevance scoring.
Cursor
A database object that enables row-by-row processing of query results, useful for operations that cannot be done in bulk.
Redis
An open-source, in-memory data store used as a database, cache, message broker, and queue with sub-millisecond response times.
 View All Databases Terms →