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")
Ответы: Re: Create and drop temp table in 8.3.4  ("Kevin Grittner")
Список: pgsql-performance

Скрыть дерево обсуждения

Create and drop temp table in 8.3.4  ("Kevin Grittner", )
 Re: Create and drop temp table in 8.3.4  ("Kevin Grittner", )
 Re: Create and drop temp table in 8.3.4  ("Kevin Grittner", )
  Re: Create and drop temp table in 8.3.4  ("Kevin Grittner", )
   Re: Create and drop temp table in 8.3.4  ("Joshua D. Drake", )
    Re: Create and drop temp table in 8.3.4  ("Kevin Grittner", )
     Re: Create and drop temp table in 8.3.4  ("Scott Carey", )
      Re: Create and drop temp table in 8.3.4  ("Kevin Grittner", )
      Re: Create and drop temp table in 8.3.4  ("Scott Marlowe", )
       Re: Create and drop temp table in 8.3.4  ("Kevin Grittner", )
        Re: Create and drop temp table in 8.3.4  ("Scott Marlowe", )
         Re: Create and drop temp table in 8.3.4  ("Kevin Grittner", )
          Re: Create and drop temp table in 8.3.4  ("Scott Marlowe", )
           Re: Create and drop temp table in 8.3.4  ("David Rees", )
           Re: Create and drop temp table in 8.3.4  (Matthew Wakeling, )
    Re: Create and drop temp table in 8.3.4  (Aidan Van Dyk, )
 Re: Create and drop temp table in 8.3.4  (Tom Lane, )

On Thu, 2008-11-06 at 13:02 -0600, Kevin Grittner wrote:
> >>> "Kevin Grittner" <> 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 по дате сообщения:

От: "Scott Marlowe"
Дата:
Сообщение: Re: Create and drop temp table in 8.3.4
От: "David Rees"
Дата:
Сообщение: Re: Create and drop temp table in 8.3.4