Re: Joao Junior 2019-09-19 <CABnPa_hdHsdypn7HtXU81B9HcrVcimotnwfzE-MWwO1etWYJzA@xxxxxxxxxxxxxx> > 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
