Re: Some pgbench results

Поиск
Список
Период
Сортировка
От Magnus Naeslund(f)
Тема Re: Some pgbench results
Дата
Msg-id 44239BEE.6040700@fbab.net
обсуждение исходный текст
Ответ на Re: Some pgbench results  ("Just Someone" <just.some@gmail.com>)
Ответы Re: Some pgbench results  ("Just Someone" <just.some@gmail.com>)
Re: Some pgbench results  (Douglas McNaught <doug@mcnaught.org>)
Список pgsql-general
Just Someone wrote:
[snip]
>>
>> mke2fs -b $bsizeb -j -J size=400 -m 1 -O sparse_super \
>>   -T largefile4 -E stride=$stride /dev/sdb
>>
>> Mounted with: mount -t ext3 -o data=journal,noatime /dev/sdb /mnt/test8
>
> That's an interesting thing to try, though because of other things I
> want, I prefer xfs or jfs anyway. I will have an extreme number of
> schemas and files, which make high demands on the directory structure.
> My tests showed me that ext3 doesn't cope with many files in
> directories very well. With xfs and jfs I can create 500K files in one
> directory in no time (about 250 seconds), with ext3 it start to crawl
> after about 30K files.
>

It might seem that I'm selling ext3 or something :) but it's the linux
filesystem I know best.
If you want ext3 to perform with large directories, there is an mkfs
option that enables directory hashing that you can try: -O dir_index.

Regards,
Magnus


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Parallel sequential scans
Следующее
От: Clyde Swann
Дата:
Сообщение: where to find pg_config....