What exactly are the relpages of a postgreSQL table?
postgresql
Solution
Yes, you are quite right. A table is called a relation (terminology from the "ER" model - the academic/theoretical background for RDBMS...) - so relpages are just that - pages containing the relation data.
the idea behind this is to provide area of continuous disk space for the table (for better performance) while still maintaining flexibility in the allocation and on disk placement of data.
Problem
I'm trying to work myself deeper into PostgreSQL and I stumbled over the relation pages of a table. I just can't wrap my head around this and I can't find any explanation of what they really are. My guess would be: A table is kinda chunked into these pages? I know that by default a page is 8 kb, so I would say that a page is an 8 kb data chunk on the disk of the table. Is that right? Or am I completely wrong on this?