Re: TRUNCATE TABLE

Поиск
Список
Период
Сортировка
От Michael Stone
Тема Re: TRUNCATE TABLE
Дата
Msg-id 20070713124435.GL31358@mathom.us
обсуждение исходный текст
Ответ на Re: TRUNCATE TABLE  (Adriaan van Os <postgres@microbizz.nl>)
Ответы Re: TRUNCATE TABLE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Fri, Jul 13, 2007 at 09:47:06AM +0200, Adriaan van Os wrote:
>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>.

xfs' slowness is proportional to the *number* rather than the *size* of
the files. In postgres you'll tend to have fewer, larger, files than you
would in (e.g.) a source code repository, so it is generally more
important to have a filesystem that deletes large files quickly than a
filesystem that deletes lots of files quickly. I'd suspect that the same
is true for mythtv.

Mike Stone

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

Предыдущее
От: Ray Stell
Дата:
Сообщение: Re: PostgreSQL publishes first real benchmark
Следующее
От: Tom Lane
Дата:
Сообщение: Re: TRUNCATE TABLE