"No Free extents", table using all allocated space but no rows!
От | Dolan, Sean |
---|---|
Тема | "No Free extents", table using all allocated space but no rows! |
Дата | |
Msg-id | 0eda9b7d13e34cc786d30c602510f3e4@lmco.com обсуждение исходный текст |
Ответы |
Re: "No Free extents", table using all allocated space but no rows!
Why using a partial index is doing slightly more logical I/O than a normal index |
Список | pgsql-general |
Environment: PostGres 13 on RedHat 7.9.
I am using logical replication (publisher/subscriber) between two databases and there are times where one of our schemas gets to 100% of allocated space (No Free Extents). I went into the schema and did a \dt+ to see the amount of size being used and I could see one of the tables somehow shows 16GB, essentially the amount of allocated size. Wanting to see what is in that table, I did a simple select * from the table and it returns no rows. Doing a count(*) also returns 0 rows.
How can the table be using all that space but there is nothing “in” the table? I don’t care about the data (as I am testing) so I can drop and recreate that one table. \dt+ would then show 0 bytes. Later, I will then create a subscription and then I will get a No Free Extents error again and again the table has filled up.
What can I look for?
Thank you
В списке pgsql-general по дате отправления: