The following table describes the limits of PostgreSQL
Table B.1. PostgreSQL limitations
| Item | Limit | Comment |
|---|---|---|
| Maximum Database Size | Unlimited | |
| Maximum Number of Databases | Unlimited | |
| Maximum Relation Size | 32 TB | Limited to 2^32 - 1 pages per relation. Can be increased by
increasing BLCKSZ and recompiling
PostgreSQL |
| Maximum Columns per Table | 250 - 1600 | Depending on column types. (More details here) |
| Maximum Row Size | 1600 GB | Assuming 1600 columns, each 1 GB in size |
| Maximum Field Size | 1 GB | |
| Maximum Identifier Length | 63 characters | Can be increased by recompiling PostgreSQL |
| Maximum Rows per Table | Unlimited | |
| Maximum Indexes per Table | Unlimited | |
| Maximum Indexed Columns | 32 | Can be increased by recompiling PostgreSQL. Limit includes
any INCLUDE columns |
| Maximum Partition Keys | 32 | Can be increased by recompiling PostgreSQL |
| Maximum Relations per Database | Unlimited | |
| Maximum Partitions per Partitioned Relations | 268,435,456 | May be increased by using sub-partitioning |