The maximum supported table size is 32 TB and it does not require large file support from the operating system. The file system size limits do not impact the large tables, as they are stored in multiple 1 GB files.
Large tables can suffer performance issues. Indexes can take much longer to update and query performance can degrade. In this recipe, we will see how to measure the size of a table.
We can see the size of a table by using this command:
postgres=# select pg_relation_size('pgbench_accounts');
The output of this command is as follows:
pg_relation_size ------------------ 13582336 (1 row)
We can also see the total size of a table, including indexes and other related spaces, as follows:
postgres=# select pg_total_relation_size('pgbench_accounts');
The output is as follows:
pg_total_relation_size ------------------------ 15425536 (1 row)
We can also use a psql
command, like this:
postgres=# \dt+ pgbench_accounts ...