2

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?

3
  • Unrelated to your problem, but: Postgres 9.3 is no longer supported you should plan an upgrade as soon as possible. – a_horse_with_no_name Jul 7 '20 at 15:22
  • What do you mean by same memory space? Do you mean same disk space? You could also provide the table's DDL and the DML of your INSERTs! – Vérace Jul 7 '20 at 17:44
  • I bet you have a TEXT column in your table? p.s. welcome to the forum! – Vérace Jul 8 '20 at 0:43
3

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.

1
  • I answered a similar question here and would be interested in your opinion - I just hope I haven't made any errors! – Vérace Jul 9 '20 at 4:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.