Re: Why does PostgreSQL ftruncate before unlink?

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: Why does PostgreSQL ftruncate before unlink?
Дата
Msg-id CA+bJJbxjn1ExMsuSm5myJUcT1C_oEUCEk8-1e+o1huyhMb5acQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why does PostgreSQL ftruncate before unlink?  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Список pgsql-general
On Mon, Feb 24, 2014 at 6:38 PM, Jon Nelson <jnelson+pgsql@jamponi.net> wrote:
> Here is an example.
>
> % time     seconds  usecs/call     calls    errors syscall
> ------ ----------- ----------- --------- --------- ----------------
>  99.95    3.207681        4182       767           ftruncate
>   0.05    0.001579           1      2428      2301 unlink

Are this times for unlink after ftruncate? Because ( in linux which is
the one I use in the desktops and I'm familiar with ) unlinks of big
files are slow too, so to have a more meaningful comparison you would
need to time ftruncate+unlink and plain unlink of same files, IIRC
they take nearly equal time.

Francisco Olarte.


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

Предыдущее
От: Jon Nelson
Дата:
Сообщение: Re: Why does PostgreSQL ftruncate before unlink?
Следующее
От: Brian Crowell
Дата:
Сообщение: GSSAPI/SSPI and mismatched user names