Re: Create and drop temp table in 8.3.4 - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: Create and drop temp table in 8.3.4
Date
Msg-id 1225999071.1204.14.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to Re: Create and drop temp table in 8.3.4  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Create and drop temp table in 8.3.4  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
On Thu, 2008-11-06 at 13:02 -0600, Kevin Grittner wrote:
> >>> "Kevin Grittner" <Kevin.Grittner@wicourts.gov> wrote:
> > If I find a particular tweak to the background writer or some such
> is
> > particularly beneficial, I'll post again.
>
> It turns out that it was not the PostgreSQL version which was
> primarily responsible for the performance difference.  We updated the
> kernel at the same time we rolled out 8.3.4, and the new kernel
> defaulted to using write barriers, while the old kernel didn't.  Since
> we have a BBU RAID controller, we will add nobarrier to the fstab
> entries.  This makes file creation and unlink each about 20 times
> faster.

Woah... which version of the kernel was old and new?

>
> -Kevin
>
--


pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Create and drop temp table in 8.3.4
Next
From: "Kevin Grittner"
Date:
Subject: Re: Create and drop temp table in 8.3.4