What is the capacity of a table in PostgreSQL?
Loading
What is the capacity of a table in PostgreSQL?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Muhammad Imran AnsariPosted Oct 31, 2022, 5:56 AM
Maximum Table Size is 32 TB. You can use the following methods to get the size of table:
The pg_relation_size() function is used to get the size of a table.
Syntax: select pg_relation_size('table_name');
To make the result readable, one can use the pg_size_pretty() function. The pg_size_pretty() function takes the result of another function and formats it using bytes, kB, MB, GB or TB as required.
SELECT pg_size_pretty (pg_relation_size('country'));
Rajanikant HawaldarPosted Oct 31, 2022, 5:03 AM
32 TB