Re: slow commits with heavy temp table usage in 8.4.0 - Mailing list pgsql-hackers

From Alex Hunsaker
Subject Re: slow commits with heavy temp table usage in 8.4.0
Date
Msg-id 34d269d40908070923w4728a21aybb5b0b34c71dd508@mail.gmail.com
Whole thread Raw
In response to Re: slow commits with heavy temp table usage in 8.4.0  ("Todd A. Cook" <tcook@blackducksoftware.com>)
List 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 by date:

Previous
From: Sam Mason
Date:
Subject: Re: Fixing geometic calculation
Next
From: Tom Lane
Date:
Subject: Re: Fixing geometic calculation