PostgreSQL Limitations

PostgreSQL Limitations – Understanding What PostgreSQL can do for you and when not recommend PostgreSQL 

ItemUpper LimitComment
database sizeunlimited
number of databases4,294,950,911
relations per database1,431,650,303
relation size 32 TBwith the default BLCKSZ of 8192 bytes
rows per tablelimited by the number of tuples that can fit onto 4,294,967,295 pages
columns per table1600further limited by tuple size fitting on a single page; see note below
field size1 GB
identifier length63 bytescan be increased by recompiling PostgreSQL
indexes per tableunlimitedconstrained by maximum relations per database
columns per index32can be increased by recompiling PostgreSQL
partition keys32can be increased by recompiling PostgreSQL


Was this article helpful?

Related Articles