Re: Delete huge Table under XFS

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