🎁 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

SQL
Structured Query Language — the standard language for managing and querying data in relational databases.
Database Proxy
A middleware server that sits between applications and databases, providing connection pooling, load balancing, and query routing.
PostgreSQL
An advanced open-source relational database known for its reliability, feature richness, and standards compliance.
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.
Crosstab Query
A query that transforms rows into columns, creating a pivot table view of aggregated data.
Connection Pool
A cache of database connections that can be reused, avoiding the overhead of creating new connections for each request.
 View All Databases Terms →