Re: Delete huge Table under XFS

Поиск
Список
Период
Сортировка
От Christoph Berg
Тема Re: Delete huge Table under XFS
Дата
Msg-id 20190919172713.GA6865@msg.df7cb.de
обсуждение исходный текст
Ответ на Re: Delete huge Table under XFS  (Joao Junior <jcoj2006@gmail.com>)
Список pgsql-performance
Re: Joao Junior 2019-09-19 <CABnPa_hdHsdypn7HtXU81B9HcrVcimotnwfzE-MWwO1etWYJzA@mail.gmail.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



В списке pgsql-performance по дате отправления:

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: Slow query on a one-tuple table
Следующее
От: Luís Roberto Weck
Дата:
Сообщение: Re: Slow query on a one-tuple table