I have a small schema in PostgreSQL v13 with only schema structure and still no data.
What I have seen, that I got some
pg_toast tables for normal tables although there is no data inside. I have a simple table with 5 columns, a couple of them are varchar=200 length and inte=19 length.
Why am I getting those
pg_toast tables when I did not insert any data into the table. I can see the relation of the
pg_toast table in
pg_class with the
These tables have 0 kbytes data according to:
pg_relation_size(reltoastrelid) AS toast_size
The only ones that have
pg_toast data are: