Re: slow commits with heavy temp table usage in 8.4.0

Поиск
Список
Период
Сортировка
От Alex Hunsaker
Тема Re: slow commits with heavy temp table usage in 8.4.0
Дата
Msg-id 34d269d40908070923w4728a21aybb5b0b34c71dd508@mail.gmail.com
обсуждение исходный текст
Ответ на Re: slow commits with heavy temp table usage in 8.4.0  ("Todd A. Cook" <tcook@blackducksoftware.com>)
Список pgsql-hackers
On Fri, Aug 7, 2009 at 10:10, Todd A. Cook<tcook@blackducksoftware.com> wrote:
> Alex Hunsaker wrote:

>> With double the number of files maybe something
>>
>> simple like turning on dir_index if you are ext3 will help?
>
> Thanks for the tip.  Doing "tune2fs -O +dir_index" didn't seem to make
> a difference, which is kinda expected for an existing directory.  When
> I get a chance, I'll try to recreate the filesystem.

e2fsck -D should also do the trick.

> -- todd
>


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

Предыдущее
От: Sam Mason
Дата:
Сообщение: Re: Fixing geometic calculation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Fixing geometic calculation