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

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.

A pattern where records are marked as deleted with a flag or timestamp rather than being physically removed from the database.

MVCC (Multi-Version Concurrency Control)

A technique where the database maintains multiple versions of data to allow concurrent reads and writes without locking.

CTE (Common Table Expression)

A temporary named result set defined within a SQL statement using the WITH clause, improving query readability and enabling recursion.

The process of copying and maintaining database data across multiple servers for redundancy, failover, and read scaling.

View All Databases Terms →