---
title: "Partition — Database Glossary | Xata"
description: "A physical division of a large table into smaller, more manageable pieces based on a partition key. PostgreSQL supports range, list, and hash partitioni..."
source: "https://xata.io/glossary/partition"
---

# Partition

Core Database

A physical division of a large table into smaller, more manageable pieces based on a partition key. PostgreSQL supports range, list, and hash partitioning. Queries targeting a specific partition value can skip unrelated partitions (partition pruning).

Related terms

[Partition Pruning](/glossary/partition-pruning)

[← Back to glossary](/glossary)