What are the limitations of PostgreSQL?

Table K.1. PostgreSQL Limitations ItemUpper LimitCommentrows per tablelimited by the number of tuples that can fit onto 4,294,967,295 pagescolumns per table1600further limited by tuple size fitting on a single page; see note belowfield size1 GBidentifier length63 bytescan be increased by recompiling PostgreSQLDocumentation: 13: Appendix K. PostgreSQL Limits www.postgresql.org › docs › limits

Read more

What are the advantages and disadvantages of PostgreSQL?

The advantages and disadvantages of PostgreSQL at a glance AdvantagesDisadvantagesHighly expandableExpandable documentation only available in EnglishLargely compliant with SQL standardComparatively low reading speedPossible to process complex data types (e.g. geographical data)Flexible full text searchPostgreSQL: features of the open source database – IONOS www.ionos.com › Digital Guide › Server › Know-how › PostgreSQL

Read more