Re: TRUNCATE TABLE

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: TRUNCATE TABLE
Дата
Msg-id 87tzs865hy.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: TRUNCATE TABLE  (Adriaan van Os <postgres@microbizz.nl>)
Список pgsql-performance
"Adriaan van Os" <postgres@microbizz.nl> writes:

> That's a remarkable advice, because XFS is known to be slow at creating and
> deleting files, see <http://en.wikipedia.org/wiki/XFS> and
> <http://everything2.com/index.pl?node_id=1479435>.

I think this is a case of "you're both right". XFS may have to do more work
than other filesystems for meta-information updates. However It still only has
to do a constant or nearly constant amount of work. So it may be slower at
managing a large directory of thousands of small files than ext3, but it's
faster at deleting a single 1G file than ext3.

On mythtv the experience is that if you use ext3 and delete a large file while
recording another program you can expect the new recording to lose stutter at
that point. The large delete will lock out the recording from writing to the
filesystem for several seconds.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


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

Предыдущее
От: Adriaan van Os
Дата:
Сообщение: Re: TRUNCATE TABLE
Следующее
От: Jean-Max Reymond
Дата:
Сообщение: Re: TRUNCATE TABLE