Re: Bottlenecks with large number of relation segment files

Поиск
Список
Период
Сортировка
От Florian Weimer
Тема Re: Bottlenecks with large number of relation segment files
Дата
Msg-id 51FF8EC1.9050209@redhat.com
обсуждение исходный текст
Ответ на Re: Bottlenecks with large number of relation segment files  (John R Pierce <pierce@hogranch.com>)
Ответы Re: Bottlenecks with large number of relation segment files
Список pgsql-general
On 08/05/2013 10:42 AM, John R Pierce wrote:
> On 8/5/2013 1:01 AM, KONDO Mitsumasa wrote:
>> When we open file, ext3 or ext4 file system seems to sequential search
>> inode for opening file in file directory.
>
> no, ext3/4 uses H-tree structures to search directories over 1 block
> long quite efficiently.

And the Linux dentry cache is rather aggressive, so most of the time,
only the in-memory hash table will be consulted.  (The dentry cache only
gets flushed on severe memory pressure.)

--
Florian Weimer / Red Hat Product Security Team


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

Предыдущее
От: hamann.w@t-online.de
Дата:
Сообщение: Re: incremental dumps
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bottlenecks with large number of relation segment files