Re: Why does PostgreSQL ftruncate before unlink?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why does PostgreSQL ftruncate before unlink?
Дата
Msg-id 5141.1393214856@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Why does PostgreSQL ftruncate before unlink?  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Ответы Re: Why does PostgreSQL ftruncate before unlink?  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Список pgsql-general
Jon Nelson <jnelson+pgsql@jamponi.net> writes:
> On Sun, Feb 23, 2014 at 9:49 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> If memory serves, the inode should get removed during the next checkpoint.

> I was moments away from commenting to say that I had traced the flow
> of the code to md.c and found the comments there quite illuminating. I
> wonder if there is a different way to solve the underlying issue
> without relying on ftruncate (which seems to be somewhat expensive).

Hm.  The code is designed the way it is on the assumption that ftruncate
doesn't do anything that unlink wouldn't have to do anyway.  If it really
is significantly slower on popular filesystems, maybe we need to revisit
that.

            regards, tom lane


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

Предыдущее
От: Jon Nelson
Дата:
Сообщение: Re: Why does PostgreSQL ftruncate before unlink?
Следующее
От: Felix.徐
Дата:
Сообщение: How to convert a double value to a numeric datum type in pgsql?