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?

Improve this question
3
  • Unrelated to your problem, but: Postgres 9.3 is no longer supported you should plan an upgrade as soon as possible.
    – user1822
    Jul 7, 2020 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, 2020 at 17:44
  • I bet you have a TEXT column in your table? p.s. welcome to the forum!
    – Vérace
    Jul 8, 2020 at 0:43

1 Answer 1

Reset to default
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.

Improve this answer
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, 2020 at 4:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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