Re: Create and drop temp table in 8.3.4

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Create and drop temp table in 8.3.4
Дата
Msg-id 1225999071.1204.14.camel@jd-laptop.pragmaticzealot.org
обсуждение исходный текст
Ответ на Re: Create and drop temp table in 8.3.4  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: Create and drop temp table in 8.3.4  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список 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 по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Create and drop temp table in 8.3.4
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Create and drop temp table in 8.3.4