Re: slow commits with heavy temp table usage in 8.4.0

From: Alex Hunsaker <badalex(at)gmail(dot)com>
To: "Todd A(dot) Cook" <tcook(at)blackducksoftware(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: slow commits with heavy temp table usage in 8.4.0
Date: 2009-08-07 16:23:27
Message-ID: 34d269d40908070923w4728a21aybb5b0b34c71dd508@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Aug 7, 2009 at 10:10, Todd A. Cook<tcook(at)blackducksoftware(dot)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
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Sam Mason 2009-08-07 16:30:03 Re: Fixing geometic calculation
Previous Message Tom Lane 2009-08-07 16:16:08 Re: slow commits with heavy temp table usage in 8.4.0