I couldn't see any growth in table size when I added a row in the relevant table. I see the same memory space even after adding 5 rows. Could anyone please help me and explain what I'm doing wrong?
1 Answer
PostgreSQL tables are stored in 8kB blocks. A new row will be added to the first best block that has enough free space. Only if there is no block with free space, the table will be extended.
Keep inserting more rows, and eventually the table will grow.
same memory space
? Do you meansame disk space
? You could also provide the table's DDL and the DML of your INSERTs!