This topic describes the limits of PolarDB for PostgreSQL.
|Maximum number of files
Maximum number of files: includes user table files, database system table files (approximately 1,000), and log files. An Apsara PolarDB table (non-partition table) occupies three files: data file, visibility map file, and FSM file. Each index indicates a file if indexes are used. The following error message appears when you create a table after the maximum number of files is reached:
could not create file
In this case, you need to delete some tables or upgrade the specifications of your cluster.
|Root privilege of databases
|PolarDB for PostgreSQL does not support the superuser privilege. Instead, it supports the polar_superuser privilege as a subset of the superuser privilege.