On Fri, 2021-02-19 at 17:58 +0530, dbatoCloud Solution wrote:
> I want to find out each row size of a table in PostgreSQL?
> I got pg_column_size() function. Could you please someone help me? Will this function return size in KB or MB?
If your table rows are several KB in size, you may have a problem.
pg_column_size() measures the size in bytes.
In my experience the best measure is to create a table, fill it with some 10000
rows and divide the table size by the row count.
There is substantial overhead for each row, and there will be overhead and
fragmentation on the block level too.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com