Re: Delete huge Table under XFS

From: Christoph Berg <myon(at)debian(dot)org>
To: Joao Junior <jcoj2006(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Delete huge Table under XFS
Date: 2019-09-19 17:27:13
Message-ID: 20190919172713.GA6865@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Re: Joao Junior 2019-09-19 <CABnPa_hdHsdypn7HtXU81B9HcrVcimotnwfzE-MWwO1etWYJzA(at)mail(dot)gmail(dot)com>
> A table with 800 gb means 800 files of 1 gb. When I use truncate or drop
> table, xfs that is a log based filesystem, will write lots of data in its
> log and this is the problem. The problem is not postgres, it is the way
> that xfs works with big files , or being more clear, the way that it
> handles lots of files.

Why is the runtime of a DROP TABLE command important? Is anything
waiting for it?

Christoph

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Luís Roberto Weck 2019-09-19 18:30:08 Re: Slow query on a one-tuple table
Previous Message Michael Lewis 2019-09-19 17:21:26 Re: Slow query on a one-tuple table