Re: Delete huge Table under XFS
Andreas Kretschmer <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <[email protected]> |
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