Am 19.09.19 um 17:59 schrieb Joao Junior:
I have a table that Is not being use anymore, I want to drop it.
The table is huge, around 800GB and it has some index on it.
When I execute the drop table command it goes very slow, I realised
that the problem is the filesystem.
It seems that XFS doesn't handle well big files, there are some
discussion about it in some lists.
PG doesn't create one big file for this table, but about 800 files with
1GB size each.
I have to find a way do delete the table in chunks.
Why? If you want to delete all rows, just use TRUNCATE.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
